I want to format cells that only contain numbers so that if the number
is <0 then the word "Kip" is displayed after the number in the same
cell.

So if the cell = 0 or blank nothing would be displayed. Can this be
done?

The cell would also need to be capable of being summed.

Thanks

Use a custom format of 0"Kip";;""

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
...
I want to format cells that only contain numbers so that if the number
is <0 then the word "Kip" is displayed after the number in the same
cell.

So if the cell = 0 or blank nothing would be displayed. Can this be
done?

The cell would also need to be capable of being summed.

Thanks