Yes/No Display

[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.

 

[Frank Kabel]

Hi Phil
format the cell with the following custom format (goto 'Format -
Cells'):
"Yes";"No";