Excel 2002 cell format

[Guest]

How do I format a cell to display a number range like 7-
11? No matter how I format it the cell is displayed as a
date or a number 37813.

 

[J.E. McGimpsey]

Preformat the cell as text, or precede yor entry with an apostrophe
(')