View Single Post
  #3   Report Post  
Fredrik Wahlgren
 
Posts: n/a
Default


"N Harkawat" wrote in message
...
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


This should work OK if you only have to do so ocassionally. What you really
should ask is if you can make the exporting program create a file with the
values you want.

/Fredrik