Hi Michael,
Im not sure why this happens and as far as Ive found out so far, there is no
standard Excel setting to fix it.
If you are encountering the problem on regular basis it may be worhtwhile
wristting a Macro to incorporate the Datevalue fix

Regards

"Michael Chang" wrote in message
...
Thanks. That worked.

It's a helluva lot better then double clicking into 4000 cells but I guess
I
was hoping to find out why this happens and if there some setting in Excel
which can be changed to prevent it.

Regards,
Michael

"Andoni " wrote in message
...
sorry if i am Wrong!
But I think, i use to from VBA:
go to data/text to columns and press finish
and in my work use to work, but I haven't use it long time ago!


---
Message posted from http://www.ExcelForum.com/