Microsoft Office Forums - View Single Post - NumberFormat: Capitalised Weekday Letters???

Thread: NumberFormat: Capitalised Weekday Letters???

View Single Post

Old

04-16-2012, 10:57 PM

tinfanide

tinfanide is offline

tinfanide uses Windows 7 64bit

Windows 7 64bit tinfanide uses Office 2010 32bit

tinfanide uses Office 2010 32bit

Office 2010 32bit

Expert

The original poster

Join Date: Aug 2011

Posts: 312

tinfanide is on a distinguished road

Default

NumberFormat: Capitalised Weekday Letters???

Code:

Cell.NumberFormat = "yyyy/mm/dd DDD"

I cannot find ways to capitalise the weekday letters both in VBA and Cell Format Menu (Ctrl+1).

Code:

ddd

or

Code:

DDD

just returns weekdays in small letters.

Reply With Quote