yes, for text, e.g.: xx
have a column want to sort "off-lines" to end, instead of NOT situation ="",
have to use characters.. (do not see a ready made custom format for text).

"T. Valko" wrote:

To "hide" 0s:

0;-0;;@

But I'm guessing you want to do it for some other value!

--
Biff
Microsoft Excel MVP


"Nastech" wrote in message
...
hi, is there a way to make a specific text, in a column to "not" appear?
have tried variations on use of 0 example:

[=0]"";0 can not get to work for text, thanks