number format

[satish]

I want to change number format to indian number format
form american number format for example:

the american format is like
200,200,000.00
I want to change it as indian format

2,00,20,000.00

 

[Bob Phillips]

Adding to M ike's response,
#","##","##","###.00;-#","##","##","###.00

to use the same format for negative numbers with a preceding minus sign

--

HTH

Bob Phillips

#","##","##","###.00

news:[email protected]...