Months List: changing the case

M

Mr. Tambourine

I did a months list as it is teached in the book Financial Statements
but I can't change the case of the month title.
I mean, the date format is mmmm dd, yyyy and it is displayed like thi
example:
january 31, 2004
february 29, 2004
march, 31 2004

I would like to change the the first character to become a capita
letter:
January 31, 2004
February 29, 2004
March, 31 2004

I hope someone can help me!
Thanks
 
D

David McRitchie

The following is not a valid ate in any country.
march, 31 2004


The others you should be able to format with the format you show
by simply reentering them in some manner.

-- F2, then enter
-- copy an empty cell (no formula, no content), and then select the
area of the dates edit, paste special, add
-- use my TRIMALL macro on my join.htm page.
-- data, text to columns, fixed width, choose something like 31 columns
so nothing overflows, choose date format of the correct format.


The Text to columns appears to actually correct your March date
by ignoring the comma on inputting it.
 
N

Norman Harker

Hi Mr. Tamborine!

How have you got these dates?

I can replicate by using

=LOWER(TEXT(TODAY(),"mmmm dd, yyyy"))

In that case:

=PROPER(TEXT(TODAY(),"mmmm dd, yyyy"))
Will get what you want.

But that's the only way I can see how you get that.
 
Top