An Excel Tutorial for Using the Dollar Function.

Posted on November 5, 2007 
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

  Here are a few posts the other readers recommend you check out.

If you right click on a cell it’s possible to format the Cells to a chosen currency. But it’s also possible to use the Dollar function to convert the Cells.

 

To convert the Numbers in Excel into the Dollar currency you need to follow the next 3 steps.

  • Open your Microsoft Excel spreadsheet and enter numeric values into Cell A2:A10.
  • Select the Cells B2:B10 and type the following formula =Dollar(A2) or =Dollar(A2.2)

The A is the refrence to the Cell that calculates the formula and the .2 is the number of decimals. When this is not entered in the formula Microsoft Excel calculates with 2 decimals.

  • Than press “CTRL+Enter”

Excel Tip Trick

 

 

 

 

 

 

 

 

 

 

As you can see, our Microsoft Excel standard setting is in Euros, this Excel Formula can be used in every desired currency.

Do you want to see more? This is related...

Invite your friends to the World of Office.
Did you ever thought about publishing your own eBook or PDF report?
Invite your friends to the World of Office.
Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 3 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!


If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.





Comments

Leave a Reply