coma setting

  • Thread starter Thread starter prasad
  • Start date Start date
P

prasad

How to set comas in Excel 2000 in Indian curency.

for example in need : 1,23,45,685.00 like this

it showing 12,345,685.00 like this


i do not know setting the comas please tell me.

prasad
 
Prasad

Excuse my ignorance, but if this is a 'standard' format for numerals in
India then you may be able to set this up for all applications through
regional settings in control panel in windows (Start>Control Panel>Regional
settings)

If not you can achieve it with a custom number format in XL
(Format>Cells...>Custom). Check out custom formats in help for the detail

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top