View Single Post
  #5   Report Post  
Gord Dibben
 
Posts: n/a
Default

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.