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

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" [email protected] wrote in message
> news:[email protected]...
> 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" <[email protected]> wrote in message news:[email protected]...
>
> 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" [email protected] wrote in message
> > news:[email protected]...
> > 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" [email protected] wrote in message
>> news:[email protected]...
>> 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" [email protected] wrote in message
>>> news:[email protected]...
>>> 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.