Formatting with currency symbol

D

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
 
B

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)
 
Top