formatting a cell to display the correct date.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to format a cell to automatically display the current year with only
inputting the current date. For example, I want the cell to display "
Thursday, Feb 23, 2006 " when I type in "Feb 23" or just "2/23". I had
formatted the cell to do this but for some reason the program thinks the year
is 2004. I know the time and date on my computer are correct. The worksheet I
am trying to use was created in 2004. Does that have something to do with my
problem? Please help.
 
Check Tools > Autocorrect to see if there is an entry to replace 2006 with
2004...

Vaya con Dios,
Chuck, CABGx3
 
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

Help with formatting the date. 6
Excel date formats 2
formatting dates 12
Date / month trouble 3
Date Format Problem 1
Custom Date Format 3
Default Cell Format Changed? 5
How do I sum #s in a column based on dates in another column 3

Back
Top