Yes/No Display

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

I have data imported from Access 2003 into Excel 2003 via
a Database Query. My Yes/No check boxes from Access
display as 1 or -. Is there a way to have display as Yes
or No in Excel?

Thanks in advance for any help.
 
Hi Phil
format the cell with the following custom format (goto 'Format -
Cells'):
"Yes";"No";
 
Back
Top