Date format and upper case

T

tamarakay

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.
 
F

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"))
 
T

tamarakay

YOU, are the MAN!!

Thank you so much.

Frank Kabel said:
Hi
AFAIK a format could not achieve this but the following formula in a
helper column maybe:
=UPPER(TEXT(A1,"MMM-D-YY"))
Click to expand...
 
T

tamarakay

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.
 
Top