Number to Text Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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")
 
Dodo,

Thks for your help.

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

Thks again.
 
Another simple way:

=A1=1


--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
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.
 
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
 
Back
Top