You obviously missed the part where Kasper said "format e.g. the rows to the
number format before you import the data?"

"before", not "after".

Personally I would choose text, rather than number format, but you need to
ensure that the data comes in with that format, so if you are importing
external data you need to specify that format for the relevant columns in
the import dialogue. Once it is stored as a different format, changing the
display format will change only the display, not the stored value.
--
David Biddulph

"Rolf Barbakken" wrote in message
...
"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