Glad it helped.
--
David Biddulph

"Janneman" wrote in message
...
Thank you David!
This worked just fine!

"David Biddulph" wrote:

You may need to look at your date format settings in Windows/ Regional
Options (accessed through Control Panel, not Excel). Then try
re-entering
the data.

Once the date is stored (as a number), reformatting the cell in Excel
will
not change the underlying date stored.
--
David Biddulph

"Janneman" wrote in message
...
Have tried to write in 3/5 and have it look like 03-May back, but excel
always comes back with 05-March! Have tried to format cells with both
dates
and specials and also tried the "text to columns" but nothing works.
Anyone who can solve this problem?

Thanks!