View Single Post
  #2   Report Post  
Bernard Liengme
 
Posts: n/a
Default

Precede the 1-1 with an apostrophe. I will not show in the cell or in a
print out.
best wishes
Bernard

"AaronMahl" wrote in message
...
How can I stop excel from correcting data I put in a cell? For instance,
I
type in
1-1 and it automatically makes it Jan00
I want to be able to use the dash without having it be a date.