| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I display numbers of 12 digits or more? | Excel Discussion (Misc queries) | |||
| Adjusting display on Y axis to leave out some digits values. | Charts and Charting in Excel | |||
| Display every 3rd category name but still display latest month | Charts and Charting in Excel | |||
| How do I enter a SSN but only display the last four digits? | Excel Discussion (Misc queries) | |||
| month & year format in two digits | Excel Discussion (Misc queries) | |||
Linear Mode
