February 6, 2009, Newsletter Issue #294: Excel´s DOLLAR function - what does it do?

Tip of the Week

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

About LifeTips

Now one of the top on-line publishers in the world, LifeTips offers tips to millions of monthly visitors. Our mission mission is to make your life smarter, better, faster and wiser. Expert writers earn dough for what they know. And exclusive sponsors in each niche topic help us make-it-all happen.

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


Guru Spotlight
Sherril Steele-Carlin