MrExcel Publishing
Your One Stop for Excel Tips & Solutions

display leading zeros


Posted by Scott Barrett on December 17, 2001 12:51 PM

I am trying to display 01/2050 in excel. Is there a
custom format that will accomplish this?


Posted by Mark W. on December 17, 2001 12:59 PM

I trust you're enter a date for January 2050. If so,
use mm/yyyy

Posted by Jack on December 17, 2001 1:06 PM

Try MM/YYYY or MM-YYYY or MM YYYY see what looks nice
HTH
Jack in UK

Posted by JACK on December 17, 2001 1:08 PM

Sorry Mark W, not refreshed prior to post, my error!