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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number Separator 2
Indian Comma style 10
Number format 3
HDMI is a terrible format and I wish it never existed 2
How do i assign separators? 0
number formats for y-axis 1
Number Format: 1,000,000 = 1 4
I'm over my head with this function 5

Back
Top