View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MadHatter8_10 MadHatter8_10 is offline
external usenet poster
 
Posts: 1
Default Excel-How Do I prevent data conversion to date format

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.