I never thought of that.. Thanks!

excelent Wrote:
14000 / 100 = 140.00 format as numbers and 2 decimal plases


"rennersc" skrev:


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




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