software

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

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 formatgt;cellsgt;number
gt;decimal places 1.Hi,

Go to Format cells, Custom format and enter

#,,.0

Regards

Govind.

nastech wrote:
gt; Hi, is there a way to custom format a cell, to read millions (all numbers) to
gt; same as divided by 1 million, with 1 decimal after the period? thanks...
gt;
gt; i.e.: 25,052,000 will read 25.1

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

quot;Govindquot; wrote:

gt; Hi,
gt;
gt; Go to Format cells, Custom format and enter
gt;
gt; #,,.0
gt;
gt; Regards
gt;
gt; Govind.
gt;
gt; nastech wrote:
gt; gt; Hi, is there a way to custom format a cell, to read millions (all numbers) to
gt; gt; same as divided by 1 million, with 1 decimal after the period? thanks...
gt; gt;
gt; gt; i.e.: 25,052,000 will read 25.1
gt;

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

#,,.0 (# comma comma period zero)quot;susubeequot; wrote:

gt; Govind,
gt;
gt; Do the commas represent the number of digits before the decimal point? So
gt; if the number was 100,000,000 would it still display properly or would you
gt; change the format to
gt;
gt; #,,,.0
gt;
gt; Thanks,
gt; Susu
gt;
gt; quot;Govindquot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; Go to Format cells, Custom format and enter
gt; gt;
gt; gt; #,,.0
gt; gt;
gt; gt; Regards
gt; gt;
gt; gt; Govind.
gt; gt;
gt; gt; nastech wrote:
gt; gt; gt; Hi, is there a way to custom format a cell, to read millions (all numbers) to
gt; gt; gt; same as divided by 1 million, with 1 decimal after the period? thanks...
gt; gt; gt;
gt; gt; gt; i.e.: 25,052,000 will read 25.1
gt; gt;

Hi,

Each comma represents a 000.

Govind

nastech wrote:
gt; tried it thanks, think comma's represent triple zero places / 1000x, looks
gt; like:
gt; if you didn't catch it:
gt;
gt; #,,.0 (# comma comma period zero)
gt;
gt;
gt; quot;susubeequot; wrote:
gt;
gt;
gt;gt;Govind,
gt;gt;
gt;gt;Do the commas represent the number of digits before the decimal point? So
gt;gt;if the number was 100,000,000 would it still display properly or would you
gt;gt;change the format to
gt;gt;
gt;gt;#,,,.0
gt;gt;
gt;gt;Thanks,
gt;gt;Susu
gt;gt;
gt;gt;quot;Govindquot; wrote:
gt;gt;
gt;gt;
gt;gt;gt;Hi,
gt;gt;gt;
gt;gt;gt;Go to Format cells, Custom format and enter
gt;gt;gt;
gt;gt;gt;#,,.0
gt;gt;gt;
gt;gt;gt;Regards
gt;gt;gt;
gt;gt;gt;Govind.
gt;gt;gt;
gt;gt;gt;nastech wrote:
gt;gt;gt;
gt;gt;gt;gt;Hi, is there a way to custom format a cell, to read millions (all numbers) to
gt;gt;gt;gt;same as divided by 1 million, with 1 decimal after the period? thanks...
gt;gt;gt;gt;
gt;gt;gt;gt;i.e.: 25,052,000 will read 25.1
gt;gt;gt;