Format date to UPPERCASE

  • Thread starter Thread starter Bruce LeBlanc
  • Start date Start date
B

Bruce LeBlanc

Excel 97: Is there a way to format the date, currently set to "dddd, mmmm d,
yyyy", in uppercase letters?
 
Hi Bruce,

If by "Date" you're referring to the current date, this formula should
accomplish what you're looking for:

=UPPER(TEXT(NOW(),"dddd, mmmm d,yyyy"))

I hope this helps.
Paul
 
Niek and Paul,

Thanks guys! I have already changed the dates in three worksheets and will
change more as I encounter the lowercase date format. I hadn't thought of
incorporating the NOW() or TODAY() references, but I'm sure I'll use these
too.

BTW, is there a good website (or websites) that list all Excel 97 (and 2000)
functions, with descriptions and examples? The www.ronperson.com (Special
Edition, Using Microsoft Excel 97 / QUE) site is currently under
construction.

--
Bruce LeBlanc
If by "Date" you're referring to the current date, this formula should
Click to expand...
accomplish what you're looking for:
=UPPER(TEXT(NOW(),"dddd, mmmm d,yyyy"))

I hope this helps.
Paul
Click to expand...
"Niek Otten" <[email protected]> wrote:
Click to expand...
=UPPER(TEXT(A1,"dddd, mmmm d, yyyy")) in another cell. Any calculations
Click to expand...
will > still have to be done with the original date, because the new cell is
text.
--
Regards,

Niek Otten
Microsoft MVP - Excel
Click to expand...
mmmm d, yyyy", in uppercase letters?
 
Hi Bruce,
Not all but there are quite a few functions and examples in

A reference to definitely download and maintain on your computer
Excel Function Dictionary -- by Peter Noneley
http://homepage.ntlworld.com/noneley
workbook with 157+ sheets, each with an explanation and example of an Excel function.
 
Back
Top