View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GD GD is offline
external usenet poster
 
Posts: 83
Default Access to Excel check box conversion

Not sure if this is an Excel or Access question, but here goes:

Previously, when I performed a copy and paste from an Access query result to
an Excel spreadsheet, the check box values would convert from -1 to Yes, and
0 to No. For some reason, they no longer convert to anything, and are
transferred as -1 and 0.

Can anyone tell me how this happened, and how I can get back to getting the
values to convert to Yes and No??

Thanks!!
--
GD