Custom Formatting

[Guest]

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

 

[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

 

[Govind]

Hi,

Go to Format cells, Custom format and enter

#,,.0

Regards

Govind.

 

[Guest]

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

 

[Guest]

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

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

 

[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)


: