Hi,

Check your table design in Access and make sure it is not a Boolean data
type, but is Text.

If this does not work, please tell us how you are getting the data from
Access to Excel.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"pauld" wrote:

Intermittently when I export a query from Access to Excel, a "NO" in one of
the text fields in Access (contains YES, NO, and N/A) seems to get changed to
a "0" (zero) in Excel.

Is there any way to prohibit Excel from changing the NO to 0 ?

Doesn't Excel take its cell format from what's being imported?