Hi,

As Gord said this does not convert the 5000000 to 5 it just changes the
display. If you want to convert a lot of number in the same way:

1 Enter 1000000 in an empty cell
2. Copy the cell
3. Highlight all the cells you want to convert and choose Edit, Paste
Special, Divide

--
Thanks,
Shane Devenshire


"Newbee" wrote:

How do I convert 5000000 on a spread sheet to 5.0 without having to divide by
1000000.