need help in converting numeric string to date...

[MrGee]

Hi!
I have a string of numbers, "30310" which needs to be represented as a date... 3/10/2003. The first digit is for the year, the next two are for the month, and the last two are for the day.

Can someone help me with a formula or mask that would convert this?

Thank you !!

 

[gnaga]

Book30
	A	B	C	D
1	30310	3/10/2003
2
Sheet1

GNaga

 

[kskinne]

this will also work, and will account for situations where the year is either one digit or two digits:

Book2
	A	B	C	D
1	30310	03/10/03
2	40310	03/10/04
3	50310	03/10/05
4	60310	03/10/06
5	70310	03/10/07
6	80310	03/10/08
7	90310	03/10/09
8	100310	03/10/10
Sheet1

 

[Mark W.]

=TEXT(A1+20000000,"0000-00-00")+0