NumberFormat: Capitalised Weekday Letters???

		Microsoft Office Forums > Microsoft Excel > Excel Programming
NumberFormat: Capitalised Weekday Letters???

04-17-2012, 04:46 AM

tinfanide

Windows 7 64bit NumberFormat: Capitalised Weekday Letters???

Office 2010 32bit

Expert

Join Date: Aug 2011

Posts: 312

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"))

Tags

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:16 PM.