I have 400 employees spread across 20 excel worksheets.

When I try to filter by employee name excel does not recognise the text in
cells that are formatted as "general".

Any ideas on resolving this? I have tried changing the relevent firlds to
text but to no avail.

Any ideas?

Thanks

Dave.