Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to find/replace data in column
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format based on data from another column | Excel Discussion (Misc queries) | |||
2 Column Data lookup | Excel Discussion (Misc queries) | |||
Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
Comparing Cells and Displaying Data | Excel Worksheet Functions | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions |