How to find/replace data in column

  • Thread starter Thread starter Rock
  • Start date Start date
R

Rock

Hi,

In Excel I have a column of 0's as text and I want to change the whole
column to 1 but still as text.

How can I do this?

I tried a find/replace, but the 1 was entered as a number not as text.

Thanks
Rock
 
Thank you Gord...

The column I wish to change is actually K.

Does this mean the A1 in the formula should in fact be K1 ?

Rock
 
Rock

In an adjacent column.

=IF(A1="0",TEXT(A1,"1"))

Drag/copy down.


Gord Dibben Excel MVP
 
Also see Dave Peterson's answer to your other post in microsoft.public.excel
for an alternative.


Gord
 
Back
Top