How to display month in 2 digits?

E

Eric

Does anyone have any suggestion on how to display month in 2 digits?
For example, MONTH(NOW()) is 5, but I would like to show 05.
Thanks in advance for any suggestions
Eric
 
M

Mike H

Hi,

Formatting the cell with a custom format of 00 (That's zero - zero) seems to
work.

Mike
 
E

Eric

Thank you very much for suggestions.

I need to CONCATENATE a string like that
=CONCATENATE("This Month is: ",month(now())
Could you please give me any suggestions on how to set the format within
concatenate function - String?
This Month is 05
Thank you very much for any suggestions
Eric
 
B

Bob Phillips

="This Month is: "&TEXT(MONTH(TODAY()),"00")

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top