Not possible unless you change the function that returns the TRUE or FALSE

Like if you have

=A25

change that to

=--(A25)

then use your custom format

"Y";;"N";




--
Regards,

Peo Sjoblom



"yahee1266" wrote in message
...
I need to display boolean worksheet values not as TRUE or FALSE, but as "Y"
and "N" without the use of conditional formatting, macros or functions; a
custom format.

The custom format:
"Y";;"N";
works if the field value is numeric, but not for boolean expressions or
values.