check
http://excelforum.com/showthread.php?t=373459

Mangesh


"Nathan" wrote in message
...
When I import date, the dates appear in the following format:

20050801 (yyyy/mm/dd)

This is August 1st 2005.

However, when I format cells and go to custom and tell Exel that the the
format is yyyy/mm/dd it returns the value #######################.

How do it translate this date format (20050801) into the correct date
format, that Exel recognizes as a date, so I can begin to work and
calculate
with it?

Thanks in advance...

Nathan