Excel formula or formatting to change number

Topic

New Reply

I have a column of numbers like

[TABLE=”width: 123″]
[TR]
[TD]42,045,532[/TD]
[/TR]
[TR]
[TD]42,086,369[/TD]
[/TR]
[TR]
[TD]42,168,835[/TD]
[/TR]
[TR]
[TD]42,151,253

I actually need them to read 42.045532
42.086369
42.168835

Is there a way i can add a custom format to formula to change the numbers? thanks for the help[/TD]
[/TR]
[/TABLE]

Reply | Quote

Replies

A Custom format like:
0.000000,,

Will keep the values (eg 42045532), but display as if they were 1 millionth (42.045532)

To actually convert the values, put in a cell the value 1000000, select that cell, copy it and then select the range of values, paste-special, and press divide.

Steve

Reply | Quote