the formula worked great but I need to keep the results in the A column.
--
Jerry Arnone
PMP, IT PROJECT+, CCNA, MCSE, CCA, CNA,
A+, SECURITY+, MS Project White Belt
"CLR" wrote:
Save your data and use a copy for this exercize...........
Assuming your data in Column A, put this in B1 and copy down........
=IF(A1=1,"Yes","No")
Then highlight the column and do Copy PasteSpecial Values to get rid of
the formulas..........then delete column A if you wish.......
Vaya con Dios,
Chuck, CABGx3
"Jerry Arnone, PMP" wrote in message
...
I have a field formated as general. The field contains either 1 or is
left
blank. If the field has a 1 I want to replace it with Yes and if the
field
is blank I want to replace it with No.
any help is appreciated.
--
Jerry