Why does it display #### in my cell?
in [Functions]
|
From: Lindsey-Star on 13 Mar 2010 22:30 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.
From: Dennis Tucker on 13 Mar 2010 23:05 Try making the column width larger. "Lindsey-Star" <Lindsey-Star(a)discussions.microsoft.com> wrote in message news:3E7ABCEA-4E8A-49D3-99FA-B41047DF029F(a)microsoft.com... > 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.
From: Bob Phillips on 14 Mar 2010 08:29 Those are hash signs not pound signs, a pound is � -- HTH Bob "Lindsey-Star" <Lindsey-Star(a)discussions.microsoft.com> wrote in message news:3E7ABCEA-4E8A-49D3-99FA-B41047DF029F(a)microsoft.com... > 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.
From: Fred Smith on 14 Mar 2010 09:45 Because you haven't given it enough room to display the result. Widen the column, or use a smaller font. Regards, Fred "Lindsey-Star" <Lindsey-Star(a)discussions.microsoft.com> wrote in message news:3E7ABCEA-4E8A-49D3-99FA-B41047DF029F(a)microsoft.com... > 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.
From: Dennis Tucker on 14 Mar 2010 10:56
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" <fsmith11(a)yahooo.com> wrote in message news:#Q3Qny3wKHA.4636(a)TK2MSFTNGP06.phx.gbl... > Because you haven't given it enough room to display the result. Widen the > column, or use a smaller font. > > Regards, > Fred > > "Lindsey-Star" <Lindsey-Star(a)discussions.microsoft.com> wrote in message > news:3E7ABCEA-4E8A-49D3-99FA-B41047DF029F(a)microsoft.com... >> 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. > |