| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
replacing only zeros
Hello,
I have an excel spread sheet that contains numerous zeros in cells. I would like to replace the zeros with the words hi; however I do not want to replace zeros in cells that are part of other numbers like 2.07. I would like the cell that has the value 2.07 to remain 2.07 but a cell with the value of 0 should be changed to hi. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format a cell to keep leading zeros. | New Users to Excel | |||
| zero supress leading zeros when chg format from text to number | Excel Worksheet Functions | |||
| Excel file saved as csv - dropping zeros | Excel Discussion (Misc queries) | |||
| Displaying leading zeros in an Excel spreadsheet | Excel Discussion (Misc queries) | |||
| Leading Zeros in Numeric Values | Excel Worksheet Functions | |||
Threaded Mode
