View Single Post
  #39 (permalink)  
Old 02-22-2008, 01:17 PM
extraction extraction is offline
Junior Member
 
Join Date: Feb 2008
Posts: 1
iTrader: (0)
extraction is on a distinguished road
Default Problem with Autocompletion Changing Nubers to Dates

Hello-

That should say "numbers' in the thread title

Using Excel 2007 last night at home doing a simple schedule template for about 10 employees.

The problem I'm having is that whenver I enter a time range into a cell it is being changed to a date when I leave the cell. For ex. if someone is working 8-5 it changes this to 5-Aug, a 10-7 shift becomes 7-Oct, etc. I turned off autocomplete for cells to no avail.

I saved the file in the older format but editing here at work I have the same issue on Excel 2003.

Some setting must have changed b/c when I first started working on the worksheet it was leaving my entries alone.

Any help appreciated

Thanks

Last edited by extraction : 02-22-2008 at 01:19 PM. Reason: spelling
Reply With Quote