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

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

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

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

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

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

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


'

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.