Formatting a Yes/No field

  • Thread starter Thread starter troy
  • Start date Start date
T

troy

I have a query to an Access database.
The values of Yes/No are showing in excel as 0's and 1's.

Is there a way to format this so it displays as Yes or No?

I don't want to add new columns using a if stmt as my
Yes/No columns come in the middle of output.....

thx.
 
try this. modify to suit.

Sub changenumbers()
Dim c As Range
For Each c In [h1:h2]
If c = 0 Then c = "Yes"
If c = 1 Then c = "No"
Next
End Sub
 
Troy,

You can try a number forma like
"Yes";;"No".
The cell values will still be 0 an 1, but No and Yes will be displayed.

HTH
Anders Silvén
 
Back
Top