Custom Number Format

S

shyryih

I would like to display my number from 1,000,000 to
10,00,000.
Thanks in advance for any assistance
regards
Dominic
 
J

J.E. McGimpsey

One way:

Format/Cells/Number/Custom:

[>=10000000]##\,##\,##\,##0.00;[>=100000]"##\,##\,##0.00;"##,##0.00
 
Top