View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Why does it display #### in my cell?

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 £