If I enter 01/01/2015 into an Excel column it gets translated into 1/1/2015. I right click and click on Format Cells... and see that the format is *3/14/2001.

I have some other cells in this spreadsheet that say 01/01/2015 and right clicking on those shows the format to be 03/14/2001. Problem is... that's only for existing cells. On new cells 03/14/2001 doesn't even appear as a format that I can select.

Is there a way to make new cells in a particular column use the format 03/14/2001 such that 01/01/2015 stays as 01/01/2015?


Format it as mm/dd/yyyy under "Custom". That will force the leading zero for day and month.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.