I created a spreadsheet with list wizard in excel. In the initial version
one
of the colum settings was formatted as a list with the source as yes, no.
After modifying the column I changed it so that it was formatted at text.
However when I try to enter free text it will only allow yes or no. I have
checked the settings and they no longer have the list setting with the
source
of yes or no.
I have Excel 2004 for mac