Fomat Columns.NumberFormat for Yes No values 1

[vbajock]

I need to format a column that contains 0 (for false) and -1 (for True) with Yes or No. Is there a format using columns.number format that will do this?

Thanks

 

[SkipVought]

hi,

No NumberFormat that I am aware of.

Why not in a helper column, assuming that your 0, -1 values are in column A, beginning in A2, then on row 2
[tt]
=if(A2=0,"NO",if(A2=-1,"YES",""))
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[vbajock]

I'm using the "copyrecordset" method of ADO to pull the data from SQL Server, which doesn't give that much cell-by-cell control. If I use the Format Column dialog it has an option to set the column format for Yes/No values, I find it odd that it does not offer the same thing via code. I can find anything on doing it for booleans anywhere.

 

[SkipVought]

If I use the Format Column dialog it has an option to set the column format for Yes/No values

Turn on your Macro Recorder and do THAT. Then check out your recorded code. Post back with your recorded code if you need help customizing.

Let us know how things turn out.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[vbajock]

Worked like a champ. I don't know why I didn't think of that....

xlws.colums(iCol).NumberFormat = """Yes"";""Yes"";""No"""

transforms boolean -1 0 to Yes or No.