General Number field has 19820431. How to convert to 04/31/1982?

I'm afraid that would be impossible since April only has 30 days!

As long as there is always a 4 digit year, 2 digit month and 2 digit day:

=DATE(--LEFT(A1,4),--MID(A1,5,2),--RIGHT(A1,2))

Biff

"Leigh" wrote in message
...