Why does it display #### in my cell?

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.

Try making the column width larger.



"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.

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.

Because you haven't given it enough room to display the result. Widen the
column, or use a smaller font.

Regards,
Fred

"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.

In my opinion, the hash marks are a mistake made by Microsoft. For normal
text, when you enter a string that is larger than the cell can display it
just runs over the cells next to it.

Display-wize, it's not a big deal to me because it indicates that my column
width is too small.

However, it is a huge deal to me because when a macro reads the contents of
the same cell, ##### is returned instead of the proper value.



"Fred Smith" wrote in message
...
Because you haven't given it enough room to display the result. Widen the
column, or use a smaller font.

Regards,
Fred

"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.

Depends upon location Bob.

In Canada # is known as a pound sign.

As in "For more options please press a number key followed by the pound
sign"


Gord

On Sun, 14 Mar 2010 12:29:17 -0000, "Bob Phillips"
wrote:

Those are hash signs not pound signs, a pound is £

Just for fun...
On a worksheet ...
Insert Symbol, (under Basic Latin) the # has the name "Number Sign"

= = = = =


On 3/14/10 12:21 PM, Gord Dibben wrote:
Depends upon location Bob.

In Canada # is known as a pound sign.

As in "For more options please press a number key followed by the pound
sign"


Gord

On Sun, 14 Mar 2010 12:29:17 -0000, "Bob Phillips"
wrote:

Those are hash signs not pound signs, a pound is £

... when a macro reads the contents
of the same cell, ##### is returned instead of the proper value.

Hmmm. Not sure what you have set up. Is there anything here that will
help?

Sub Demo()
Range("A1").Value = 12345678901234#
Columns("A:A").ColumnWidth = 2 'Narrow to display ##
Debug.Print Range("A1").Text
Debug.Print Range("A1").Value
End Sub

Returns:
##
12345678901234

= = = = =
Dana DeLouis



On 3/14/2010 10:56 AM, Dennis Tucker wrote:
In my opinion, the hash marks are a mistake made by Microsoft. For
normal text, when you enter a string that is larger than the cell can
display it just runs over the cells next to it.

Display-wize, it's not a big deal to me because it indicates that my
column width is too small.

However, it is a huge deal to me because when a macro reads the contents
of the same cell, ##### is returned instead of the proper value.



"Fred Smith" wrote in message
...
Because you haven't given it enough room to display the result. Widen
the column, or use a smaller font.

Regards,
Fred

"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.



--
= = = = = = =
HTH :)
Dana DeLouis

Right.........number or pound sign.

"hash" is what my mother used to make from leftover roast beef and potatoes.


Gord

On Sun, 14 Mar 2010 12:32:20 -0400, Dana DeLouis
wrote:

Just for fun...
On a worksheet ...
Insert Symbol, (under Basic Latin) the # has the name "Number Sign"

= = = = =


On 3/14/10 12:21 PM, Gord Dibben wrote:
Depends upon location Bob.

In Canada # is known as a pound sign.

As in "For more options please press a number key followed by the pound
sign"


Gord

On Sun, 14 Mar 2010 12:29:17 -0000, "Bob Phillips"
wrote:

Those are hash signs not pound signs, a pound is £

Right.........number or pound sign.

The proper name of the # character is 'octothorpe'.

"hash" is what my mother used to make from leftover roast beef and potatoes.

I consumed a lot of hash in my college days, but it wasn't the kind my
Mom made.


Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com



On Sun, 14 Mar 2010 09:55:38 -0700, Gord Dibben gorddibbATshawDOTca
wrote:

Right.........number or pound sign.

"hash" is what my mother used to make from leftover roast beef and potatoes.


Gord

On Sun, 14 Mar 2010 12:32:20 -0400, Dana DeLouis
wrote:

Just for fun...
On a worksheet ...
Insert Symbol, (under Basic Latin) the # has the name "Number Sign"

= = = = =


On 3/14/10 12:21 PM, Gord Dibben wrote:
Depends upon location Bob.

In Canada # is known as a pound sign.

As in "For more options please press a number key followed by the pound
sign"


Gord

On Sun, 14 Mar 2010 12:29:17 -0000, "Bob Phillips"
wrote:

Those are hash signs not pound signs, a pound is £