Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date problem
I have created a custom date format "YEAR ENDED "dd mmmm yyyy which displays
as YEAR ENDED 31 March 2006. I can't get the date to appear in uppercase. I've tried the format as DD MMMM YYYY but this has no effect. Is there a way of doing this? Al |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date problem
PE wrote:
I have created a custom date format "YEAR ENDED "dd mmmm yyyy which displays as YEAR ENDED 31 March 2006. I can't get the date to appear in uppercase. I've tried the format as DD MMMM YYYY but this has no effect. Is there a way of doing this? Al Instead of using cell formatting, use the following formla: ="YEAR ENDED "&UPPER(TEXT(NOW(),"dd mmmm yyyy")) replace NOW() with any or formula that contains the date that you are interested in. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date is being changed to a number (problem) | Excel Discussion (Misc queries) | |||
Imported Data Date Format Problem | Excel Discussion (Misc queries) | |||
Date Formatting Problem | Excel Discussion (Misc queries) | |||
Login Logout Date Problem | Excel Worksheet Functions | |||
Date and Time Picker Control problem | Excel Discussion (Misc queries) |