B
Bruce LeBlanc
Excel 97: Is there a way to format the date, currently set to "dddd, mmmm d,
yyyy", in uppercase letters?
yyyy", in uppercase letters?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
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
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
B
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
text.
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
accomplish what you're looking for:If by "Date" you're referring to the current date, this formula should
=UPPER(TEXT(NOW(),"dddd, mmmm d,yyyy"))
I hope this helps.
Paul
"Niek Otten" <[email protected]> wrote:
will > still have to be done with the original date, because the new cell is=UPPER(TEXT(A1,"dddd, mmmm d, yyyy")) in another cell. Any calculations
text.
mmmm d, yyyy", in uppercase letters?--
Regards,
Niek Otten
Microsoft MVP - Excel
D
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.
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.
B
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
I've downloaded the EFD and bookmarked http://homepage.ntlworld.com/noneley
for future reference. I'll look at your site first.
--
Bruce LeBlanc
David McRitchie said: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.