Anyone know off-hand the command to convert a number:
0000000456
to:
4.56
I tried this:
Application.FixedDecimal = True
Application.FixedDecimalPlaces = 2
Which works, but not if you're copying the data from another workbook.
Any ideas?
Garrett (MIS)
--
prepotency
------------------------------------------------------------------------
prepotency's Profile:
http://www.excelforum.com/member.php...o&userid=24155
View this thread:
http://www.excelforum.com/showthread...hreadid=378042