One way - use an adjacent helper col

Assuming numbers running in Y2 down
Put in Z2: =IF(Y20,"active",Y2)
Copy down. Kill the formulas in col Z with an "in-place" copypaste special
as values. Delete col Y.

If you want any blank cells in col Y to return as "blanks", ie:""
then use instead in Z2:
=IF(Y2="","",IF(Y20,"active",Y2))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Colin Hayes" wrote:
HI

In column Y I have a row of numbers.

I need to change them so that the cells which are 0 stay the same , and
cells with numbers greater than 0 in them are replaced with the word
'Active' .

Can someone help with this?

Thanks.