How to display month in 2 digits?
 

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

How to display month in 2 digits?
 

Hi,

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

Mike

"Eric" wrote:

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

How to display month in 2 digits?
 

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

"Mike H" wrote:

Hi,

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

Mike

"Eric" wrote:

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

How to display month in 2 digits?
 

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

--
---
HTH

Bob


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



"Eric" wrote in message
...
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

"Mike H" wrote:

Hi,

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

Mike

"Eric" wrote:

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

How to display month in 2 digits?
 

Another alternative:

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

Regards,
Fred.

"Eric" wrote in message
...
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

"Mike H" wrote:

Hi,

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

Mike

"Eric" wrote:

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