How to find/replace data in column

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
 
D

Dave Peterson

Select the range
format|Cells|number tab
choose Text

Type 1
hit ctrl-enter to fill those cells with text 1.
 
Top