You mean Checkboxes?
You can use a helper cell:
=if(a1=true,"Yes","No")
Then hide that linkedcell (if you want).
Gldenboy2 wrote:
I have a long colum full of textboxes in excel. When the boc is checked it
returns true, and false for unchecked. I would like to change this so that
it returns Yes for checked and No for unchecked. How can I make this happen
--
Dave Peterson
|