Thread: 198K to 198000?
View Single Post
  #1   Report Post  
mdudlik
 
Posts: n/a
Default 198K to 198000?


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