Replacing '0' with '..'

[magilla]

disclaimer: noob that knows almost nothing about excel.


so, I'm working with a pretty massive data set. I wanted to increase the scale of an entire column by 100x, so I made a new column, H, and set the following H=I*100.

unfortunately, doing so enters a zero in the cell when the cells in the column I had no data. The value should not be 0, but should be blank. I'm running time-regressions and replacing '0' with '..' will work. I did this using an IF function in the past, but haven't been able to get it to work this go around.

Any suggestions?


NEVERMIND. Got it. did the following:

H109=IF(I109=0,"..",I109*100)



...now i just need to learn how to delete my pointless thread.

[ratcat]

G'day and welcome to the forum

Try this in col H1 then copy drag down

Please Login or Register  to view this content.

HTH