Keep a previous year when entering down a column

  • Thread starter Thread starter Karlene
  • Start date Start date
K

Karlene

I am entering dates in a column that are from 2009 and the system defaults to
the current year, so I have to change them or not use a year. Is there an
easier way?
 
A date by definition contains a year. You may elect to "hide" the "year"
from view by formatting.
 
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

Excel Vba to change displayed year automatically. 14
Remove date format? 3
How to enter excel dates for last year? 10
Sumif (Year) 3
Hello happy new year to all, Text box input for year of purchase 0
how do I use different year for date auto complete 3
Power Pivot Variance Column 0
Changing worksheets to the next years dates 2

Back
Top