Why does it display #### in my cell?
in [Functions]
|
From: Gord Dibben on 14 Mar 2010 15:44 Thanks for the contribution Chip. But I'm sure you didn't inhale<g> Gord On Sun, 14 Mar 2010 14:35:19 -0500, Chip Pearson <chip(a)cpearson.com> wrote: >>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 <delouis(a)bellsouth.net> >>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" >>>> <bob.phillips(a)somewhere.com> wrote: >>>> >>>>> Those are hash signs not pound signs, a pound is � >>>>
From: Joe User on 14 Mar 2010 15:56 "Bob Phillips" <bob.phillips(a)somewhere.com> 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" <bob.phillips(a)somewhere.com> wrote in message news:en3u4H3wKHA.1176(a)TK2MSFTNGP06.phx.gbl... > 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: Bob Phillips on 14 Mar 2010 18:31 "Joe User" <joeu2004> wrote in message news:OhYA4B7wKHA.2436(a)TK2MSFTNGP04.phx.gbl... > "Bob Phillips" <bob.phillips(a)somewhere.com> 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). I think that I know that, seeing as I have many in my wallet.
From: Dennis Tucker on 14 Mar 2010 18:38 Thanks! The issue I was having was when I was using the .Text output. I need to use the .Value output instead. "Dana DeLouis" <delouis(a)bellsouth.net> wrote in message news:ebEwoW5wKHA.5936(a)TK2MSFTNGP04.phx.gbl... > > ... 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" <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. >>> > > > -- > = = = = = = = > HTH :>) > Dana DeLouis
From: Joe User on 14 Mar 2010 19:32
"Dennis Tucker" <dennis13030(a)cox.net> wrote: > Thanks! The issue I was having was when I was using the .Text output. > I need to use the .Value output instead. Well, there are good reasons to use .Text sometimes. I had assumed that's what you meant. So your point was well-taken insofar as any VBA code that uses .Text (for good reason) needs to be prepared to deal with "#" symbols in numeric cells. But I would not call that a mistake in design. It is simply an arbitrary decision. My complaint is: I think that Excel is inconsistent in its handling of column width adjustments. ----- original message ---- "Dennis Tucker" <dennis13030(a)cox.net> wrote in message news:%23feJUc8wKHA.732(a)TK2MSFTNGP06.phx.gbl... > Thanks! The issue I was having was when I was using the .Text output. I > need to use the .Value output instead. > > > > "Dana DeLouis" <delouis(a)bellsouth.net> wrote in message > news:ebEwoW5wKHA.5936(a)TK2MSFTNGP04.phx.gbl... >> > ... 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" <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. >>>> >> >> >> -- >> = = = = = = = >> HTH :>) >> Dana DeLouis > |