filter format

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I'm having trouble filtering a list for text values "10-
32", "8-32" etc. because in Excel XP automatically
changes my filter to a date value e.g. Oct-2032, Aug-2032.
Excel 97 never used to do this.
Does anyone know a way around this?
 
You need to reformat the cells, which at present are Date Types.
Reformat the cells as TEXT.
 
Back
Top