NumberFormat: Capitalised Weekday Letters???

tinfanide · #1 04-16-2012, 10:57 PM

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.

Colin Legg · #2 04-17-2012, 01:19 AM

Hi,

As far as I know you can't do this with number formats alone. You could convert the value to uppercase using the UPPER() function in a formula though.

tinfanide · #3 04-17-2012, 02:15 AM

Quote:

Originally Posted by Colin Legg

Hi,

As far as I know you can't do this with number formats alone. You could convert the value to uppercase using the UPPER() function in a formula though.

Yes, it does when there is no number format. But my data is formatted, the VBA codes in the attached file do not work at all. Please kindly take a look at the file below.
test.xlsm
Many thanks!

tinfanide · #4 04-17-2012, 04:46 AM

These make it at one go.

VBA:

Code:

ActiveCell.Value = UCase(WorksheetFunction.Text(Date, "yyyy/mm/dd ddd"))

Formula:

Code:

=UPPER(TEXT(TODAY(),"yyyy/mm/dd ddd"))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
letters are dashes	pmd	Word	5	03-05-2012 08:08 PM
My letters disappear	come rain or shine	Word	2	10-11-2011 02:18 PM
Problem with merged letters	maaario	Word	0	06-24-2011 06:22 PM
My weekday function aint working	FraserKitchell	Excel	12	05-25-2010 04:42 PM
sending personal letters	misteroffice	Word	3	12-23-2008 08:51 AM