The Excel DOLLAR function converts any number to text using the currency format.
If cell A1 contains 123,
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,
Would return £123.00000
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.