I have an excel worksheet where the current date is automatically inserted. What I would like to know is, how do I get Excel to capitalize the month automatically as well?
thanks in advance,
Eddie
I have an excel worksheet where the current date is automatically inserted. What I would like to know is, how do I get Excel to capitalize the month automatically as well?
thanks in advance,
Eddie
Re: Date
What do you mean by
Quote
Capitalize the month
Re: Date
WHat I meant to say what instead of the month being February I would like it to be FEBRUARY. I want all the letters capitalized. Sorry for the mix up.
thanks
Eddie
Re: Date
If you are putting the date in with a formula.
=UPPER(TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())),"dd mmmm yyyy"))
Re: Date
Thanks For The Help.
Eddie
Don’t have an account yet? Register yourself now and be a part of our community!