Excel, Implied Decimal
Posted by mary on February 06, 2002 10:55 AM
I need to format a numeric field, 9 positions the last two being an Implied Decimal.
i.e. 0000050.00 needs to read 000005000
How do I do this???
Posted by Mark W. on February 06, 2002 12:55 PM
Can't be done with a number format, but...
...you could convert the internal value by
entering 100 into a unused cell, copy it,
select the values to be converted, and
then Paste | Special... Values Multiply.
Format as 000000000
