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! |
#2
|
|||
|
|||
If your zero's are the results of formulas, you can wrap your formulas in an
IF statement, like =IF((YourFormula)=0,"hi",(YourFormula)) Vaya con Dios, Chuck, CABGx3 wrote in message ups.com... 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! |
#3
|
|||
|
|||
If your zeroes are *not* the results of a formula, you could try,
<Edit <Replace, Enter 0 in the "Find What" box, And "hi" (no quotes) in the "Replace With" box, And *CHECK* "Find Entire Cells Only" Then <Replace All -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "CLR" wrote in message ... If your zero's are the results of formulas, you can wrap your formulas in an IF statement, like =IF((YourFormula)=0,"hi",(YourFormula)) Vaya con Dios, Chuck, CABGx3 wrote in message ups.com... 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! |
#4
|
|||
|
|||
You can use formatting to change the zero cells:
Select all the cells that you want to format Choose FormatCells Select the Number tab Select the Custom Category In the text box, type: General;General;"hi" Click OK wrote: 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! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
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 |