View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] deniseandgavin@gmail.com is offline
external usenet poster
 
Posts: 13
Default Formatting with currency symbol

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