Set date format in Template in Excel

  • Thread starter Thread starter falcios
  • Start date Start date
F

falcios

Is there a way to set in the template so that all dates entered show as
2/6/10 not as 02/06/2010?

Thanks in advance.
 
If it's a template, you could change the format of each of the cells to what you
want.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Default date format (with shortcut keys) 2
sum columns between certain dates 1
Highlight date nearest to TODAY() 1
Compare dates in two different ranges 1
Excel Formula Bar Time Display Format 2
Pivot Table Summarizing Quirk - Please Help 1
Need difference in Hrs.mm.ss 3
Leaving a formula cell blank when data has not yet been added. 5

Back
Top