I have a column with numbers like:
33.35
21.01
42.7
12.01
21
I need to convert them all to:
3335
2101
4270
1201
2100
What would be the easiest way to accomplish this? Can it be done with a
custom number format?
Thanks!
--
TimmerSuds
------------------------------------------------------------------------
TimmerSuds's Profile:
http://www.excelforum.com/member.php...o&userid=35596
View this thread:
http://www.excelforum.com/showthread...hreadid=553615