Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO YOU TYPE - OR + IN EXCEL WITHOUT CREATING A FORMULA?
How do you type +, - etc in a cell without Excel automatically assuming that
you want to create a formula? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO YOU TYPE - OR + IN EXCEL WITHOUT CREATING A FORMULA?
Put an apostrophe to the left of the symbol.
Example: '+ You will see the apostrophe in the formula bar, but not in the cell. The cell will only show + Dave -- Brevity is the soul of wit. "jools" wrote: How do you type +, - etc in a cell without Excel automatically assuming that you want to create a formula? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO YOU TYPE - OR + IN EXCEL WITHOUT CREATING A FORMULA?
hi,
format the cell as text before type or use " ' " (no quotes) before the text hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "jools" escreveu: How do you type +, - etc in a cell without Excel automatically assuming that you want to create a formula? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO YOU TYPE - OR + IN EXCEL WITHOUT CREATING A FORMULA?
hi,
format the cell as text or type " ' " (no quotes) before the + or - etc. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "jools" escreveu: How do you type +, - etc in a cell without Excel automatically assuming that you want to create a formula? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO YOU TYPE - OR + IN EXCEL WITHOUT CREATING A FORMULA?
Hello, Marcelo!
You wrote on Tue, 19 Sep 2006 07:03:02 -0700: M format the cell as text or type " ' " (no quotes) before the M + or - etc. M hth M -- M regards from Brazil M Thanks in advance for your feedback. M Marcelo M "jools" escreveu: ?? How do you type +, - etc in a cell without Excel ?? automatically assuming that you want to create a formula? The advice to use ....'.... is obviously correct but when does the problem arise? I was interested enough to see what happens so I typed I just want see + or - into a general cell in a new worksheet. What I typed is what I got so I wonder if the problem is not with embedded operators but perhaps those at the beginning. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO YOU TYPE - OR + IN EXCEL WITHOUT CREATING A FORMULA?
The problem occurs when mathematical operators are the first character on the
left. If you were to type something like "two + two = four" Excel's calculation engine would ignore the + and = signs. However, if you were to type "-2 + 2 = 0" and you wanted to retain that text, you would have to put an apostrophe to the left of the - sign, otherwise, Excel would resolve the above statement to TRUE. Dave -- Brevity is the soul of wit. "James Silverton" wrote: Hello, Marcelo! You wrote on Tue, 19 Sep 2006 07:03:02 -0700: M format the cell as text or type " ' " (no quotes) before the M + or - etc. M hth M -- M regards from Brazil M Thanks in advance for your feedback. M Marcelo M "jools" escreveu: ?? How do you type +, - etc in a cell without Excel ?? automatically assuming that you want to create a formula? The advice to use ....'.... is obviously correct but when does the problem arise? I was interested enough to see what happens so I typed I just want see + or - into a general cell in a new worksheet. What I typed is what I got so I wonder if the problem is not with embedded operators but perhaps those at the beginning. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Excel 97 formula doesn't work in Excel 2003 | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
EDIT FORMULA BAR in excel 2003? why not? where is it? | Excel Worksheet Functions |