Thread
:
Custom format whole number to decimal
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
Custom format whole number to decimal
Try:
[100000]#\,##0\.00;##0\.00
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"TamIam" wrote in message
...
Good day,
I am currently using a custom format to automatically display a whole
number
as a number with decimals: ###0\.00 however, I was wondering if it was
possible to have a custom format perform the same function, but with a
comma
value as well e.g. (#,##0\.00) - this does not work.
--
Thanks for your help!
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann