View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Rolf Barbakken[_2_] Rolf Barbakken[_2_] is offline
external usenet poster
 
Posts: 6
Default Importing data. Problem with datatype in column

"Kasper" wrote in message
...

Is it possible to format e.g. the rows to the number format before you
import the data? That sometimes helps me



I tried this just now. I changed the format of the column to Number with two
decimals. This only caused the column to display 39845,00 where it
previously showed "1. February". A difference, but not a solution.

Thanks.

--
Rolf