Format date to UPPERCASE

[Bruce LeBlanc]

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

 

[Paul Simon]

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

 

[Bruce LeBlanc]

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

accomplish what you're looking for:

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

I hope this helps.
Paul

"Niek Otten" <[email protected]> wrote:

=UPPER(TEXT(A1,"dddd, mmmm d, yyyy")) in another cell. Any calculations

will > still have to be done with the original date, because the new cell is
text.

--
Regards,

Niek Otten
Microsoft MVP - Excel

mmmm d, yyyy", in uppercase letters?

 

[David McRitchie]

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.

 

[Bruce LeBlanc]

David,

I've downloaded the EFD and bookmarked http://homepage.ntlworld.com/noneley
for future reference. I'll look at your site first.

--
Bruce LeBlanc

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.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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.