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
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

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
 

Forum statistics

Threads
1,141,152
Messages
5,704,600
Members
421,359
Latest member
Edwardvanschothorst

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top