Question regarding a strange condition in Excel spdsht...
 

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,

Toolsoptionstransition and uncheck transition formula entry


Regards,

Peo Sjoblom

"Flop" wrote:

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,

Hey Peo:

You ROCK!

If your ever in Boston I owe you a beer.

"Peo Sjoblom" wrote:

Toolsoptionstransition and uncheck transition formula entry


Regards,

Peo Sjoblom

"Flop" wrote:

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,