Well, I'm out of formatting suggestions. How about this...

Instead of the formula returning "xx", have it return a space. The space
won't be seen and the cell will still contain a character for sorting
purposes.

If that doesn't work then I don't have any other suggestions.

--
Biff
Microsoft Excel MVP


"Nastech" wrote in message
...
or rather: [="xx"]"";General did not seem to work