I want to display the minus sign
 

How do I display the minus sign? I don't want to enter a formula, just text
or a label

I want to display the minus sign
 

Ed, one way put a ' in front of it like '-, it want show in the cell
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"ED" wrote in message
...
How do I display the minus sign? I don't want to enter a formula, just
text
or a label

I want to display the minus sign
 

Place an apostrophe in front of it.
************
Anne Troy
www.OfficeArticles.com

"ED" wrote in message
...
How do I display the minus sign? I don't want to enter a formula, just
text
or a label

I want to display the minus sign
 

Thank you.


"Paul B" wrote:

Ed, one way put a ' in front of it like '-, it want show in the cell
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"ED" wrote in message
...
How do I display the minus sign? I don't want to enter a formula, just
text
or a label

I want to display the minus sign
 

Technically, it is a single quote. The apostrophe is the upper right
key on most keyboards.
Anne Troy Wrote:
Place an apostrophe in front of it.
************
Anne Troy
www.OfficeArticles.com

"ED" wrote in message
...
How do I display the minus sign? I don't want to enter a formula,
just
text
or a label


--
Bob Miller

I want to display the minus sign
 

What country's keyboard do you have that distinguishes between
a single quote and an apostrophe. No difference on US keyboards.
Accent grave is in the upper left corner of US keyboards.


"Bob Miller" wrote in message . ..

Technically, it is a single quote. The apostrophe is the upper right
key on most keyboards.
Anne Troy Wrote:
Place an apostrophe in front of it.
************
Anne Troy
www.OfficeArticles.com

"ED" wrote in message
...
How do I display the minus sign? I don't want to enter a formula,
just
text
or a label


--
Bob Miller

I want to display the minus sign
 

Bob Miller wrote:
Technically, it is a single quote. The apostrophe is the upper right
key on most keyboards.
Anne Troy Wrote:
Place an apostrophe in front of it.
************
Anne Troy
www.OfficeArticles.com

"ED" wrote in message
...
How do I display the minus sign? I don't want to enter a formula,
just
text
or a label


'

I want to display the minus sign
 

gls858 wrote:
Bob Miller wrote:
Technically, it is a single quote. The apostrophe is the upper right
key on most keyboards.
Anne Troy Wrote:
Place an apostrophe in front of it.
************
Anne Troy
www.OfficeArticles.com

"ED" wrote in message
...
How do I display the minus sign? I don't want to enter a formula,
just
text
or a label


'

Sorry about that hit the send button by mistake.