Hello From Steved

It does this 03-Jul-2005 I would like please 03-JUL-2005

I goto Custom And typed dd-MMM-yyyy and also typed DD-MMM-YYYY

Please how can I have the month in Caps

Thanks for taking timeout on my frustrating Question.

Kludgy, but:

=UPPER(TEXT(DATEVALUE("3-Jul-2005"),"d-mmm-yyyy"))

--

Vasant



"Steved" wrote in message
...
Hello From Steved

It does this 03-Jul-2005 I would like please 03-JUL-2005

I goto Custom And typed dd-MMM-yyyy and also typed DD-MMM-YYYY

Please how can I have the month in Caps

Thanks for taking timeout on my frustrating Question.

Probably not the best solution, but you could do this.

=TEXT(A1,"dd-JUL-yyyy")

Matt


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=377583

Excellent and thankyou.

"Vasant Nanavati" wrote:

Kludgy, but:

=UPPER(TEXT(DATEVALUE("3-Jul-2005"),"d-mmm-yyyy"))

--

Vasant



"Steved" wrote in message
...
Hello From Steved

It does this 03-Jul-2005 I would like please 03-JUL-2005

I goto Custom And typed dd-MMM-yyyy and also typed DD-MMM-YYYY

Please how can I have the month in Caps

Thanks for taking timeout on my frustrating Question.