An Excel Tutorial for Using the Dollar Function.

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”

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

Leave a Reply

Our Tips and Tricks Categories

Computer Clean Up    Excel Tips & Tricks    News    Other Software

Other Tips & Tricks    Outlook    PowerPoint    Reader Questions

Submit a Tip & Trick    Vista Tips & Tricks    Word Tips & Tricks    XP Tips & Tricks

Follow Me @

Blog Extra's

Don't steal our stuff

All content is copyrighted by Promedia Blogging. Don't steal our stuff (it's bad karma), please read our Creative Commons License and contact us.

Credits for the original Theme

Machine Translations

By N2H

Sites worth checking

• Buy Dreamweaver CS4
• Computer Free Tips
• The World of Modern Men.

Promedia Blogging - IM Strategies

The company behind The World of Office is Promedia Blogging. We are a Dutch based Internet Marketing Company with an international staff from the Netherlands, the US, India and Australia.

If you have a great product and a review or banner on this blog just isn’t enough, please contact us via Promedia Blogging. We are very successful in managing large Internet Marketing Campaigns.

A short Introduction

Hi, I’m Vincent Sparreboom and I’m the guy behind the World of Office Tips & Tricks and owner of the company Promedia Blogging.

It’s the new to semi experienced computer owner that this site is aimed at. Having said this, even experienced users have already told me that reading the tips we’ve written have been helpful in refreshing their memories and reminding them of lessons once learned.

We see this blog as an informative fun learning environment where we share tips, reviews and write about software that’s useful to the day-to-day computer user.