Simply import it as it is
Then do the following
type 100 into a blank cell
copy it
select the column that hold the numbers that you need divided by 100
edit-paste special-
select divide
hit ok
'This will divide the entire range by 100




"Frustrated Excel user" <Frustrated Excel
wrote in message ...
I have some numbers that I want to import from another program into Excel
that are not shown as decimals. Rather than create a micro that takes
every
number I import and divide it by 100, is there an easier way to set up my
Excel spreadsheet so that when I import these numbers, it automatically
converts them? (e.g. they are showing as 1219 and the number should really
be
12.19)???