I got a list where Column A is 198 and column B is K, meaning 198K, and
this is about a 1600 item list. Ive been asked to convert column A to
198000, etc for 1600 different numbers.
Is there a way to do this with formatting or a formula? Also, some of
them are 107.1 meanling 107100.
If someone could help w/ this I'd appreciate it. Thanks
--
mdudlik
------------------------------------------------------------------------
mdudlik's Profile:
http://www.excelforum.com/member.php...o&userid=22624
View this thread:
http://www.excelforum.com/showthread...hreadid=374159