How to display month in 2 digits?

[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

 

[Mike H]

Hi,

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

Mike

 

[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

 

[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)

 

[Fred Smith]

Another alternative:

="This Month is:"&Text(Today(),"mm")

Regards,
Fred.