Adding a decimal to numbers
 

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

Adding a decimal to numbers
 

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

Adding a decimal to numbers
 

Enter 100 in an unused cell then copy it. Highlight the imported data and
select Paste Special Divide. Then format the imported data as number with
two decimal places

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"rennersc" wrote in
message ...

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

Adding a decimal to numbers
 

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