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

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


"susubee" wrote:

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

"Govind" wrote:

Hi,

Go to Format cells, Custom format and enter

#,,.0

Regards

Govind.

nastech wrote:
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