Hi,
I have a sheet with a bunch of numbers that look like this.

6.22
8.99
11.22
0.81

i need to turn those numbers into a 5 digit number, without the
decimal.

00622
00899
01122
00081

Does anyone know an easy way to do this?


--
silentbobafett
------------------------------------------------------------------------
silentbobafett's Profile: http://www.excelforum.com/member.php...o&userid=24126
View this thread: http://www.excelforum.com/showthread...hreadid=377460