Adding a decimal to numbers

R

rennersc

I am importing a list of dollar amounts into excel, and they do not hav
decimals to seperate the cents amounts. if there is no change then i
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

Thank
 
S

Sandy Mann

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

[email protected]
[email protected] with @tiscali.co.uk
 
Top