I am in search of this as well... over 5000 records all in date format. It is indeed a date yyyymmdd.

Problem is that whoever created the table in the database that I need to import into has the type as a decimal 😉

So - I just want to change my column so I can import it and yet Excel is outsmarting me - wanting to give me the number equivalent. I have to keep the same "date" values.

I tried copying the values into a new column = general, special, number equivalent 🙂

Insanity to outsmart what it thinks I want lol - 20110219 turns into 40593

I understand why it converts - I need to outsmart Excel for my purposes.