Prev: Control On Cell Input
Next: Setting special format for a cell
From: Gord Dibben on 14 Mar 2010 12:21
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: Dana DeLouis on 14 Mar 2010 12:32
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: Dana DeLouis on 14 Mar 2010 12:44
> ... 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: Gord Dibben on 14 Mar 2010 12:55
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: Chip Pearson on 14 Mar 2010 15:35
>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 �
>>>
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Control On Cell Input
Next: Setting special format for a cell