Formatting with currency symbol

[deniseandgavin]

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

 

[Bob Phillips]

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

--
---
HTH

Bob


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