I am importing a list of dollar amounts into excel, and they do not have
decimals to seperate the cents amounts. if there is no change then it
will put 00. I cant figure out how to add them.

Importing
14000
4005
26700
14000

Needs
140.00
40.05
267.00
140.00

Thanks


--
rennersc
------------------------------------------------------------------------
rennersc's Profile: http://www.excelforum.com/member.php...o&userid=37345
View this thread: http://www.excelforum.com/showthread...hreadid=570453