View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pauld Pauld is offline
external usenet poster
 
Posts: 8
Default ACCESS ="NO" BUT EXCEL DISPLAYS "0"

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?