Formatting Numbers Indian way

manojk71273

Board Regular
Joined
Apr 28, 2006
Messages
103
Hi All

say I have a number 123456 then it should give me the number 1.23 and if asked for more digits then as 1.23456

if number is 112345678 then the answer should be 1,123.45 or 1,123.45678

if number is less than 100000 then it should be 0.99 or 0.99999

can anybody help me?

manoj
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

manojk71273

Board Regular
Joined
Apr 28, 2006
Messages
103
please help me I really want this as I have to use this in my account statement

at present I am deviding by 1Lakh or 10 Laks or 10thousands

thanks every body

Manoj
 

Krishnakumar

Well-known Member
Joined
Feb 28, 2003
Messages
2,615
Hi,

say I have a number 123456 then it should give me the number 1.23 and if asked for more digits then as 1.23456

if number is 112345678 then the answer should be 1,123.45 or 1,123.45678

Go to Tools > Options > Edit > check fixed decimal and places: 5

HTH
 

manojk71273

Board Regular
Joined
Apr 28, 2006
Messages
103
Hi Krishna

Every time I have to give figures in Laks or crores in a/c statement

Say I have a figure 13,25,236/- then I have to show it in statement as 13.25 lakhs by formatting the cell. As the data is more every time it is not possible to devide it with 1 lakh

if the figure is less than 1 lakh say 25,234/- then the amount after formatting should show 0.25 lakhs so on

I think this will clear the confusion other wise I will post my excel file

Manoj
 

Krishnakumar

Well-known Member
Joined
Feb 28, 2003
Messages
2,615

ADVERTISEMENT

Did you try my suggestion?
 

manojk71273

Board Regular
Joined
Apr 28, 2006
Messages
103
Sorry Krishna

I was not in town for past some days

I tried your suggestion, but its a general format and applies to each file, which I was not looking for. I want to format the cells from Custom format

Manoj
 

Watch MrExcel Video

Forum statistics

Threads
1,111,910
Messages
5,541,536
Members
410,547
Latest member
htran4
Top