MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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... 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