| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find/replace data in column
See one response at your post in .excel
Rock wrote: 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 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find/replace data in column
After you change them to 1's highlight the cells | Format | Cell | Number tab
| Category: Text | OK "Rock" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find/replace data in column
That won't actually change the values to text. Changing the format won't affect
the values. pameluh wrote: After you change them to 1's highlight the cells | Format | Cell | Number tab | Category: Text | OK "Rock" wrote: 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 -- Dave Peterson |
| Reply |
| 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 | |||
Linear Mode
