|
Patch reliability is unclear, but widespread attacks make patching prudent. Go ahead and patch, but watch out for potential problems. |
I’d like to create a custom number format for dates that would produce an upper case month; e.g., 02DEC03. The closest I can get without converting the cell contents to text (=UPPER(TEXT(NOW(),”mmdddyy”))) is the “Title” case (03Dec03). Anyone know how I can get ‘DEC’ instead of ‘Dec’ and still have a number in the cell?
It sure would be nice if the date formatting for numbers was case sensitive (i.e., ddmmmyy produces 02dec03, ddMmmyy produces 02Dec03, ddMMMyy produces 02DEC03, etc.)…
Thanks.
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Notifications
