Thanks Trevor, unfortunately I get the error message "Excel cannot use the
number format you typed. Try using one of the built-in formats etc etc". Is
some kind of add-in required?
"Trevor Shuttleworth" wrote:
Try a custom format:
"which is "0" % of annual income"
Format | Cells | Number tab : Custom category | Type: ...
Regards
Trevor
"gvm" wrote in message
...
I need a worksheet function so that a cell will display "which is 17% of
annual income" where 17% is actually the value that results from a formula
involving two cell references, eg $b$24/$c$24. Is this possible? Any help
will be much appreciated, cheers....
|