1 lakh to be visible as one

[webmax]

Hi

I have a excel date in that most of the data is more than 1 lakhs

I want to show this value as 1 instead one by changing the same in the format

I tried but it is working only for 10 laksh by changing format- custom as #,,

I want the same like 1 lakh

Data Output should be
100000 1
500000 5
50000 .5
1000000 10

 

[sgmpatnaik]

@webmax

Please Try this, say your amount in A1:A4

100000
500000
50000
1000000

in B1 = A1/100000

Then Copy and Drag Down

Another Way put the Value 100000 in C1 copy it and select the range A1:A4 and past special and select divide option and ok, it is done

if any problem please inform

Thanks

 

[Hui]

Wemax

I'd suggest using a Custom Number Format

Have a read of http://chandoo.org/wp/2012/01/31/custom-number-formats-multiply-divide-by-any-power-of-10/