Auto Format
 

I am writing reference ranges in columns for lab tests and am having a
problem. In the column i want to write: 10 - 20, but everytime i change to
another column it changes to Oct 20. This is getting on my nerves. What do i
do to prevent this?

Auto Format
 

Format those cells as Text. Right click the cell or range of selected cells,
select Format Cells, and then on the Number Tab, select Text.

HTH

"Richards" wrote:

I am writing reference ranges in columns for lab tests and am having a
problem. In the column i want to write: 10 - 20, but everytime i change to
another column it changes to Oct 20. This is getting on my nerves. What do i
do to prevent this?