Number to Text Value

K

KYMO

Hey,

I have data coming from Access via ODBC with a value of 0 (NO) or 1 (YES)
from a tickbox in Access.

Is there a way I can covert these 0 & 1's to a text word in excel in another
column.

0 = NO or FALSE
1 = YES OR TRUE

Thanks in Advance.
 
D

Dodo

Hey,

I have data coming from Access via ODBC with a value of 0 (NO) or 1
(YES) from a tickbox in Access.

Is there a way I can covert these 0 & 1's to a text word in excel in
another column.

0 = NO or FALSE
1 = YES OR TRUE

Thanks in Advance.
Click to expand...

It seems too simple a solution, so probably I did not really get your
problem. ;-)))

=if(somecell=0,"NO","YES")
 
K

KYMO

Dodo,

Thks for your help.

Never come across that, coundn't even find it on the web.

Thks again.
 
R

RagDyer

Another simple way:

=A1=1


--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
D

Dave Peterson

Another option if all those values are in a single column:

Select the column
edit|replace
what: 0
with: No
replace all

and same kind of thing with 1 to Yes.
 
K

kcc

KYMO said:
Dodo,

Thks for your help.

Never come across that, coundn't even find it on the web.

Thks again.

:
Click to expand...
You could leave the cell only, but apply a custom format of "Yes";"Yes";"No"

kcc
 
Top