Software

Ask something
Question Locked

thousands seperator

0 helpful
2 replies

by ninsiimaj

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

2 replies

by vel_achary

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

This discussion is closed to new replies.