"Bob Phillips" wrote:
Those are hash signs not pound signs, a pound is £

According to Webster's Ninth New Collegiate Dictionary (1991), in the US,
"#" is used for number and for pounds (weight). And yes, £ is used for
pounds (currency).


----- original message -----

"Bob Phillips" wrote in message
...
Those are hash signs not pound signs, a pound is £

--

HTH

Bob

"Lindsey-Star" wrote in message
...
In cell I25 I have the following formula: =SUM(I11:I14)
All it displays is #####, but when I hover over it, it gives me the
correct
answer on a popup tip-like window which is $3,400. So, if it knows the
answer, why is it displaying with the pound signs instead? I think I've
tried everything.