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