Thread: DD-MON-YYYY never D-MON-YYYY
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
okey okey is offline
external usenet poster
  
Posts: 7
Default DD-MON-YYYY never D-MON-YYYY
I need to format a date column to show leading zeros in the DD part.
How do I do this?

I want 07-JUL-2009
I do not want 7-JUL-2009

Thank you
Reply With QuoteReply With Quote