thousands seperator

By ninsiimaj ·
when i write ten millions in the excell sheet, it appears as 1,00,00,000 on using thousands seperator. I want it to appear as 10,000,000 What do i do?

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Collapse -

use format cell

by vel_achary In reply to thousands seperator


before typing 10,000,000. Right click on the cell you want 10 million to appear, click on format cells.
In number 'tab' of format cells select "Text" and click ok.

I hope now you will be able to type 10,000,000.
Sakthivel Achary

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums