Custom Number Format

  • Thread starter Thread starter shyryih
  • Start date Start date
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
 
One way:

Format/Cells/Number/Custom:

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