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.