Question regarding a strange condition in Excel spdsht...

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

Guest

I have a spreadsheet in excel that everytime I type in a date in the
mm/dd/yyyy format and press return, it automatically puts an "=" in front of
my date I just entered and returns the date of 1/0/1900 because of the =
sign. Any idea on how to correct this?

Thanks,
 
Tools>options>transition and uncheck transition formula entry


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

Date format changes in mail merge using Excel worksheet as data 2
Sumproduct Question 4
Excel 2002: How to make the date format uniform ? 1
Date Formats 1
Numbers change to a date format 3
Dates in Excel 2003 1
Excel 2007 displayed dates 2
Conditional formatting of date-cell - 2007 5

Back
Top