G Guest Oct 1, 2007 #1 I want to type 1-3 (as in first through third grade) but it keeps getting converted to Jan 3 (as in the calendar). Please help!
I want to type 1-3 (as in first through third grade) but it keeps getting converted to Jan 3 (as in the calendar). Please help!
G Guest Oct 1, 2007 #2 You will need to first type a hyphen and then your text/numbers. Like this: '1-3 By entering the hyphen keeps the cell type as a text cell. This will solve your problem.
You will need to first type a hyphen and then your text/numbers. Like this: '1-3 By entering the hyphen keeps the cell type as a text cell. This will solve your problem.