AGHH! Excel will be the death of me!

[Ricochet J]

All I want to do is have 2 cells. One has 1 - 5 in it and the other has 6 - 10 in it. Instead, it always changes 1 - 5 to a date 01/05/06 and the same for 6 - 10, 06/10/06.

!!!WTF!!!

Help

 

[me227]

Right click on the cell select Format Cell.

Then from the list of choices pick Text, then enter what you want into the cell.

 

[MarcLister]

Highlight the cells, right click, Format Cells and choose the text option. 3rd from bottom in Excel 2000. You may have to re-enter the text but '1-5' and '6-10' work fine when formatted as Text.