Question

Locked

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.

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

All Answers

Collapse -

use format cell

by vel_achary In reply to thousands seperator

Hi,

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.
thanks.
Sakthivel Achary

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums