That does not "convert" the value.

Just displays the same value differently.

Hope you're not relying on 5.0 when adding up your phone bill.


Gord Dibben MS Excel MVP

On Mon, 29 Sep 2008 16:08:32 -0700, Newbee
wrote:

Found the answer on a previous post. Thanks #.00,,

"Newbee" wrote:

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