Capital Letter in Date format

[amy]

Hi,

Urgent need help is needed pertaining date format

For example, I have this date 27/07/2004 and how to
convert it to 27/JUL/04. Means month is in capital letter.

Thank you for your help.

 

[Max]

Try: =UPPER(TEXT(A1,"dd/mmm/yy"))
with the date in A1

 

[Guest]

Hi Max. It's workable.

TQ.

-----Original Message-----
Try: =UPPER(TEXT(A1,"dd/mmm/yy"))
with the date in A1

 

[Max]

Pleased to hear that!
Thanks for the feedback