Custom format whole number to decimal
Try this:
[99999]#","##0"."00;##0"."00
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"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!
|