Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |