date format

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

Guest

when i enter 3/15/2005, excel displays 1/1/1904
and the cell contains =3/15/2005

how can i make this work so that it shows my real date, which is 3/15/2005

thanks a lot
 
See your other thread. I assume that since that other message you have
changed your settings from the 1900 to the 1904 date system?
 
THANKS

David Biddulph said:
See your other thread. I assume that since that other message you have
changed your settings from the 1900 to the 1904 date system?
Click to expand...
 
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

Problem formatting dates from CSV file 2
Excel 2002 : How to eliminate the time value after the date ? 8
How to find the latest date? 2
Help with a formula 5
Change Default Auto-Fill-In month 4
DATE SORTING excel 2
Comparing Dates using Greater Than and Less than 1
Default Date Format 1

Back
Top