Custom Formatting
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
|