Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
How do I display the minus sign? I don't want to enter a formula, just text
or a label |
#2
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]()
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 |
#4
![]() |
|||
|
|||
![]()
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 |
#5
![]() |
|||
|
|||
![]() 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 |
#6
![]() |
|||
|
|||
![]()
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 |
#7
![]() |
|||
|
|||
![]()
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 ' |
#8
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
# sign in a cell | Excel Discussion (Misc queries) | |||
Minus Display | Excel Discussion (Misc queries) | |||
moving minus sign from right to left | Excel Worksheet Functions | |||
strip minus signs from right to left | Excel Discussion (Misc queries) | |||
Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions |