Thread: How to display month in 2 digits?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
  
Posts: 1,670
Default 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
Reply With QuoteReply With Quote