Date problem

  • Thread starter Thread starter PE
  • Start date Start date
P

PE

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
 
PE said:
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
Click to expand...

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.
 
Back
Top