Auto Format

[Richards]

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?

 

[Wood Grafing]

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