AnsweredAssumed Answered

Ectopic Values when Exported

Question asked by NikkiSidhu on Mar 29, 2012
Latest reply on May 7, 2012 by NikkiSidhu


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? 


Thank you!!!