Need Custom Format Help . .

[Evagrius Ponticus]

Hello all,

I have a formula that sums certain cell. I want the phrase " of 240" to appear after the sum. I know I could do & " of 240", but I have a lot of sheets and I would have to select each one individually to do that. How can I do this with custom formatting? I tried use the @ but it will not work. Thanks . .

 

[Scott Huish]

Something like this:

Custom format of:
0" of 240"

 

[Evagrius Ponticus]

yup, that works . . .thanks, that was too simple . .