Keeping Excel from Changing Data to Dates
February 16, 2002 - by Juan Pablo Gonzalez
We do Biomedical Research and we use Excel as our primary data editor. We need to enter into a cell things like 1-2 and 6-5. Yet, when we enter that, it turns it into a date like Jan-2 and Jun-5. We need to turn this off, and turning off the Autocomplete function does not do it. Have any ideas? Thanks!
- Format the Column (Or range) where you will input the data as TEXT before inputting the data.
Second, input the text with a ' starting, like this
and Excel won't translate it.