Thread: How do I set up a number to 1,23,459.00 formatting in excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Héctor Miguel
 
Posts: n/a
Default How do I set up a number to 1,23,459.00 formatting in excel?
hi, Shiji !

I want to set the custom formatting to the above said format

you will 'see' the leading commas [but]...
you may want to give it a try: - #\,##\,##0.00

[perhaps] a 'better' way: - [=100000]#\,##\,##0.00;#,##0.00

hth,
hector.


Reply With QuoteReply With Quote