Convert number to date

[Box666]

I have a field that shows as 200404 (format General) which I would like
to show as Apr2004, I have tried changeing the format to date mmyyy,
but that shows up as Sept 48 .

I feel sure this must be an easy (and often used ) procedure, can any
body advise me how best to do it please

Bob

 

[Guest]

Try this formula...

=DATE(LEFT(A1, 4), MID(A1, 5,2), 1)
Where 200404 is in Cell A1

 

[vezerid]

=TEXT(DATE(1900,--RIGHT(A2,2),1),"Mmm")&LEFT(A2,4)

HTH
Kostis Vezerides