Auto Format

R

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?
 
W

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
 
Top