Excel's DOLLAR function - what does it do?

Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Excel 2000 and other Software topics.

What does the DOLLAR function do?

Excel's DOLLAR function - what does it do?

The Excel DOLLAR function converts any number to text using the currency format.

If cell A1 contains 123,
=DOLLAR(A1)
will return £123.00 (as text, not as a number).

The default number of decimal places is 2, but the number of decimal places can be modified by adding a comma and a number after the cell reference.

In the above example,
=DOLLAR(A1,5)
Would return £123.00000

   

Comments

Nobody has commented on this tip yet. Be the first.



Name:


URL: (optional)


Comment:


Not finding the advice and tips you need on this Software Tip Site? Request a Tip Now!


Guru Spotlight
Jolyn Wells-Moran