Custom Formatting

N

nastech

Hi, is there a way to custom format a cell, to read millions (all numbers) to
same as divided by 1 million, with 1 decimal after the period? thanks...

i.e.: 25,052,000 will read 25.1
 
L

lan1g1r0

You could try making a source cell with the original number and enter a
formula to divide by 1,000,000. And then go to format>cells>number
 
S

susubee

Govind,

Do the commas represent the number of digits before the decimal point? So
if the number was 100,000,000 would it still display properly or would you
change the format to

#,,,.0

Thanks,
Susu
 
N

nastech

tried it thanks, think comma's represent triple zero places / 1000x, looks
like:
if you didn't catch it:

#,,.0 (# comma comma period zero)
 
G

Govind

Hi,

Each comma represents a 000.

Govind
tried it thanks, think comma's represent triple zero places / 1000x, looks
like:
if you didn't catch it:

#,,.0 (# comma comma period zero)


:
Click to expand...
 
Top