On Sun, 30 Sep 2007 12:11:03 -0700, MadHatter8_10
wrote:

I am trying to input symbolic numerical data that includes forward slashes ie
"5/5" in a simple excel spread sheet. However when I do so, it converts the
input into a date format ie: "5-may" or "5/5/07" Furthermore. Even if I erase
the content from the "evil" cell in question, any future integer value ( ie:
" 5 " ) entered in to that cell is converted to a date format. How do I
prevent this from happening and/or disable this function in excel. Thanks
for any and all help.

The data must be entered into the cell as TEXT.

This can be done either by

1. Format the cell as TEXT before entering the data (Format/Cells/Number/Text)
2. Precede the data with a single quote '2/2


--ron