date formatting and AutoFilter

[zappedagain]

Is there a way to make Excel NOT convert a number that looks like a date into a date? For example, if I type "6-32" Excel enters "Jun-32" in the cell.

One technique I know of is to enter it as text, "'6-32" and then Excel will leave it alone. This doesn't work though when using the AutoFilter. If I tell it to display cells where the contents contain "6-32" it enters "Jun-32" in the search criteria and doesn't find anything; I can't use the text trick there.

 

[handleman]

Format the cells as "Text".

 

[zappedagain]

What about the AutoFilter? Is there a way to turn off the conversion feature globally?

 

[joerd]

Works on my machine. Can you pick the right value from the drop-down list?

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.