Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"