date format

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

Guest

When I enter a date format 04/09/05, Excel displays 01/00 in the cell. Why is
it doing this. I have gone to format cells and formated the cell for dates,
03/14.

Any suggestions?

Thanks...
 
Sounds like you have Lotus 123 transitions set:
Tools>Options>Transition Tab
Uncheck the 2 sheet options.

Does that help?

Regards,
Ron
 
Go to tools>options>transtion and uncheck
transition formula entry using that you are actually doing

=4/9/5

which is

0.0888888888888889

and since it is less than a day it will be 02:00 AM jan 0 1900
thus the result

Regards,

Peo Sjoblom
 
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

separating date and time 5
Problem formatting dates from CSV file 2
time_report_date-wise_employee-wise 6
Date/Time 1
Subtracting time...again 2
countifs Function not giving desired result with date criteria 2
Peculiar default cell format 1
Access Running Balance in Access 1

Back
Top