Libre
been around a little
- Local time
- Today, 07:40
- Joined
- May 3, 2007
- Messages
- 660
Maybe this should be in the Excel section, but it also has to do with Access so I'm posting it here. When I have a datasheet in Access that has Boolean true/false values it reports them as 1 and 0, respectively. When I copy this data and paste it into Excel, instead of 1 or 0, it converts it to TRUE or FALSE. This is causing some problems. I tried reformatting the datatype in Excel but nothing I do seems to change it. Hoping for a quick/easy fix if there is one. Thanks for your help.