View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Custom format whole number to decimal

Try it without the backslash............

Vaya con Dios,
Chuck, CABGx3




"TamIam" wrote:

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!