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