Thread
:
How do I turn off automatic date function in XL?
View Single Post
#
5
Gord Dibben
Posts: n/a
Bob
Check your date sepearator in Windows Regional Options.
Change to something other than the decimal point.
Gord Dibben Excel MVP
On Wed, 13 Jul 2005 10:19:04 -0700, "bob condon" <bob
wrote:
I am in the process of entering values into a Microsoft XL Spreadsheet and
one of the coumns associated the value 2.13 with February 13th. This is very
frustrating since I cannot accurately sum the rows or columns with a date in
it. How do I turn off the function that automatically puts a date into the
column? The help section notes how to turn it on, but not turn it off.
Reply With Quote