Excel date format errors

S

Sally

When a date of 010503 is entered and the cells have been
formatted to a 03-18-98 date format, incorrect dates show
up. I believe it has something to do with the year 2000
dates, but I don't know how to correct it.
Can anyone help?
 

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

Autofill Date in Word 15.33 for Mac 0
VBA - exporting serial letters to single documents 0
Publisher is filling blank lines with data 2
Remove date format? 3
Cumulative formula for word table 0
Date format. 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Excel Date Formatting 0

Top