Question regarding a strange condition in Excel spdsht...

F

Flop

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,
 
P

Peo Sjoblom

Tools>options>transition and uncheck transition formula entry


Regards,

Peo Sjoblom
 
Top