Date format and upper case

[Guest]

Excel 2002 on Windows 2000

How can we format existing dates entered as 7/22/1960 to format like
JUL-7-60. Has to be upper case. We are kinda weird about upper case around
here.

Thank you.

 

[Frank Kabel]

Hi
AFAIK a format could not achieve this but the following formula in a
helper column maybe:
=UPPER(TEXT(A1,"MMM-D-YY"))

 

[Guest]

YOU, are the MAN!!

Thank you so much.

Hi
AFAIK a format could not achieve this but the following formula in a
helper column maybe:
=UPPER(TEXT(A1,"MMM-D-YY"))

 

[Guest]

I thought I already posted this once, but as of yet it is not showing up and
I do not want to appear ungrateful, so here it is again. Apologies if you get
patted on the back twice.

YOU are the MAN!

Thank you so much, this worked beautifully.