Custom Number Format

[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.E. McGimpsey]

One way:

Format/Cells/Number/Custom:

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