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
|