how to escape "+" or " -"
 

Hi all,
when I input "+" or" -", there is alway a marqueue, how can I prevent the
marqueue?

Clara
thank you so much for your help

how to escape "+" or " -"
 

i didn't understand WHAT the heck you were talking about, so i tried
it - now i understand.
when you put + or -, excel thinks it's part of a formula & is looking
for the next value of the formula, hence the marqueue (or, as some
people call it, the marching ants).
if you want JUST that character in a cell, use an apostrophe before it
& that will tell excel it is a text cell, not part of a formula
'+
or
'-

hope this helps!
susan


On Mar 22, 1:33 pm, clara wrote:
Hi all,
when I input "+" or" -", there is alway a marqueue, how can I prevent the
marqueue?

Clara
thank you so much for your help

how to escape "+" or " -"
 

Hi Susan,

Thank you very much! Here is another question.
When I use code to assign "'+" or "'-" to a range, the apostrophe is also
displayed which is not wanted. How can I do it?

Clara

thank you so much for your help


"Susan" wrote:

i didn't understand WHAT the heck you were talking about, so i tried
it - now i understand.
when you put + or -, excel thinks it's part of a formula & is looking
for the next value of the formula, hence the marqueue (or, as some
people call it, the marching ants).
if you want JUST that character in a cell, use an apostrophe before it
& that will tell excel it is a text cell, not part of a formula
'+
or
'-

hope this helps!
susan


On Mar 22, 1:33 pm, clara wrote:
Hi all,
when I input "+" or" -", there is alway a marqueue, how can I prevent the
marqueue?

Clara
thank you so much for your help

how to escape "+" or " -"
 

i didn't know, so i turned on the macro recorder & recorded inputting
'+ & '-........
this is what i got

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 3/22/2007 by Susan
'
ActiveCell.FormulaR1C1 = "'+"
Range("D4").Select
ActiveCell.FormulaR1C1 = "'-"
Range("E4").Select
End Sub

and the apostrophe disappears when it's entered when i run the code...
maybe this will give you some direction in your code?
:)
susan


On Mar 22, 4:04 pm, clara wrote:
Hi Susan,

Thank you very much! Here is another question.
When I use code to assign "'+" or "'-" to a range, the apostrophe is also
displayed which is not wanted. How can I do it?

Clara

thank you so much for your help



"Susan" wrote:
i didn't understand WHAT the heck you were talking about, so i tried
it - now i understand.
when you put + or -, excel thinks it's part of a formula & is looking
for the next value of the formula, hence the marqueue (or, as some
people call it, the marching ants).
if you want JUST that character in a cell, use an apostrophe before it
& that will tell excel it is a text cell, not part of a formula
'+
or
'-

hope this helps!
susan

On Mar 22, 1:33 pm, clara wrote:
Hi all,
when I input "+" or" -", there is alway a marqueue, how can I prevent the
marqueue?

Clara
thank you so much for your help- Hide quoted text -

- Show quoted text -