#1
|
|||
|
|||
NumberFormat: Capitalised Weekday Letters???
Code:
Cell.NumberFormat = "yyyy/mm/dd DDD" Code:
ddd Code:
DDD |
#2
|
||||
|
||||
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. |
#3
|
|||
|
|||
Quote:
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! |
#4
|
|||
|
|||
These make it at one go.
VBA: Code:
ActiveCell.Value = UCase(WorksheetFunction.Text(Date, "yyyy/mm/dd ddd")) Code:
=UPPER(TEXT(TODAY(),"yyyy/mm/dd ddd")) |
Tags |
numberformat, vba, weekdays |
|
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 |