Good Evening,
I have a field in excel that's a 1, 0 or blank " " I'll call the field "Paid". Is it better sense you make the blanks a 0 and add an additional field called BlankPaid ? Or is it better to make it a 1 character field and be done with it ?
Example data
Paid
1
0
' '...