View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Babuli Babuli is offline
external usenet poster
 
Posts: 1
Default How do I format cell for displaying value in lakhs ?

How do I format a Cell to show number in thousands, lakhs, crores
instead of thousands, millions, billions?

E.g.
By default the number 12345678, would be displayed in Excel as follows
12,345,,678.00 I would like it to be displayed as
1,23,45,678.00.

Is it possible?

Please respond.