Excel is converting numbers to date ....arrgh!

I have a HTML table with a column with numbers like

3.6
2.5
1.8
....

and so on...

When I'm trying to open this table in Excel (.csv or if I cut n paste from HTML) Excel keeps converting it to date format.

03.jun
02.may
01.aug


This wouldn't be a problem if I could only go to Format -> Cell and choose Standard or something.

The problem is it ends up like this then:

39236
39204
39295


WTF? :D

I want this!!!

3.6
2.5
1.8
....


Please help me.. thank you!

Originally Posted by oldchippy

See link to previous

http://www.excelforum.com/showthread...=numbers+dates

Thank you.


However, the problem with importing as text is that it will not go back to numbers and the auto sum and such will not work with text.

Originally Posted by MDubbelboer

i'm not sure this will actually work, but i just found this link for another post and it seems relevant

http://www.contextures.com/xlDataEntry03.html

i'll do a bit of testing to see

I tried the "Convert with Paste Special", but it didn't work here.

I'm running Excel 2003 (11.5612.5606), Norwegian btw.