Daily tips for using Microsoft Excel.

Saturday, February 16, 2002

Angie asks "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!"

Two options, 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

'1-2

and Excel won't translate it.