Uppercase Today() function
Posted by Beginner Bob on November 02, 2000 10:36 AM
I have a worksheet template which is all in uppercase letters. I have a cell which contains "=TODAY()". I would like to have this date read "NOVEMBER 2, 2000", instead of "November 2, 2000" or "11/2/00". I have changed the format of the cell to the correct format. I have also tried "=UPPER(TODAY())", and this returns the date code. Is there a way I can work around this to capitalize the month in a today function without using additional cells (like B1=A1,copy, paste special etc.) Thanks for any help.