Thanks to all! worked like a charm...and saved me time.
"Rick Rothstein (MVP -
VB)" wrote:
If all your dates will be on or after the year 2000, try this formula...
=--TEXT(A1,"2000-00-00")
Rick
"KKay" wrote in message
...
Is there a formula that would convert 80521 to a date, 05/21/08?
Or convert a text of 080521 to a date format 05/21/08?
thx, k