Ectopic Values when Exported
Hello, I'm wondering if someone can help me with this...
I have a data set that I had previously recorded.
Recently, for a checkbox field, I changed the values from "O-Yes" and "1-No" to "0-No" "1-Yes". I went back and adjusted the values for the data that had already been entered.
The problem is that now, when I export my data to excell, these values show up as "10", and NOT the 1 or 0 they should. I don't have this problem for any new data I enter.
This is a 500+ entry database so I'd really like to not have to delete and re-enter data. Is there a way around doing that?