Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 26
Default How to handle a minus sign "-" as text not as part of a formula?

When I enter something into a cell beginning with a minus sign "-" then the content
is automatically interpreted as a formula.

How can I prevent this and let Excel treat the cell content (only for this cell) as text?

Claudia

  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: How to handle a minus sign "-" as text not as part of a formula?

Hi Claudia,

I understand your frustration with Excel automatically interpreting a cell content beginning with a minus sign as a formula. Fortunately, there is a simple solution to this problem.

To prevent Excel from treating the cell content as a formula, you can add an apostrophe (') before the minus sign. This tells Excel to treat the content as text.

For example, if you want to enter
Code:
"-100"
as text, you would enter
Code:
"'-100"
(without the quotes) into the cell. The apostrophe will not be displayed in the cell, but Excel will treat the content as text.

Alternatively, you can format the cell as text before entering the content. To do this,
  1. select the cell or range of cells,
  2. right-click and select "Format Cells",
  3. in the Format Cells dialog box, select "Text" under the "Category" section and click "OK".
Now, any content entered into the cell or range of cells will be treated as text.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How to handle a minus sign "-" as text not as part of a formula?

You can start your entry with an apostrophe: '-1234 qwer

or you could preformat the cell(s) as Text, then do the data entry.

Claudia d'Amato wrote:

When I enter something into a cell beginning with a minus sign "-" then the content
is automatically interpreted as a formula.

How can I prevent this and let Excel treat the cell content (only for this cell) as text?

Claudia


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 135
Default How to handle a minus sign "-" as text not as part of a formula?

Claudia -

You can precede the minus sign with a single quote ('). The single quote
won't show in the cell (it will show in the formula bar), and it tells Excel
this is text, not a number.
--
Daryl S


"Claudia d'Amato" wrote:

When I enter something into a cell beginning with a minus sign "-" then the content
is automatically interpreted as a formula.

How can I prevent this and let Excel treat the cell content (only for this cell) as text?

Claudia

.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What does "--" (2 minus signs) do in a formula Huggy Excel Discussion (Misc queries) 1 October 21st 09 08:17 AM
How do I write an excel formula with a text answer ("yes" or "no") pat Excel Discussion (Misc queries) 1 September 9th 08 03:41 PM
How to "sign" macro with "digital certificate"? Clueless in Seattle New Users to Excel 5 March 23rd 08 03:48 AM
OK. I give. Why can't I use the "@" (at sign) in a text cell? Terry Lowe Excel Discussion (Misc queries) 4 November 13th 06 03:21 AM
How do display a "+" or "-" sign when hiding columns? DTI Tustin Setting up and Configuration of Excel 1 July 13th 06 01:21 PM


All times are GMT +1. The time now is 10:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"