View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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