Convert input data

[Jack in the UK]

Hi guys playing with :

If i input 21 say as today is 21st Feb 2002 i need to convert to Correct 21st Feb 2002

All i will input is 21??? any ideas guys rather than have 21 in one column and next column converts.

Cheers guys

Rdgs
=========
Jack

 

[Derek]

Jack
Custom format cells #"st Feb 2002"
Is that what you mean?
Derek

 

[Juan Pablo González]

Or use:

DateValue(Year(Date),Month(Date),MyInput+0)

 

[Jack in the UK]

Cheers guys...

big thanks

Rgds
===========
Jack

 

[Drew]

Jack,
You could try...
=DAY(C8)&IF(INT(MOD(DAY(C8),100)/10)=1,"th",IF(MOD(DAY(C8),10)=1,"st",IF(MOD(DAY(C8),10)=2,"nd",IF(MOD(DAY(C8),10)=3,"rd","th"))))&" "&TEXT(C8,"mmm yyyy")
where c8 houses a date but the result becomes text.

HTH,
Drew
FYI the above comes from J. Walkenbach. Someday I'll get there!