dashes and the right arrow key

[cyndi]

In excel 2003 I hit the dash key in a cell becusae it is null to me, then I
press the right arrow, and it will create a subtraction calculation, I know
if I hit the tab key it will not do this, but is there a way so I can use the
dash in one cell and then press the right arrow to move to the next column
without it caluculating?
any help would be great
thanks

[Peo Sjoblom]

No need for multiple post within 10 minutes, see a possible answer to your
previous post

Regards,

Peo Sjoblom


"cyndi" <cyndi@discussions.microsoft.com> wrote in message
news:96963619-4B3E-4BF5-A2C5-26D279AE5529@microsoft.com...
> In excel 2003 I hit the dash key in a cell becusae it is null to me, then
I
> press the right arrow, and it will create a subtraction calculation, I
know
> if I hit the tab key it will not do this, but is there a way so I can use
the
> dash in one cell and then press the right arrow to move to the next column
> without it caluculating?
> any help would be great
> thanks

[cyndi]

the second post was a mistake, the least you could do is give me the benifit
of the doubt and ignored it, I tried to remove it, and as far as know there
isn't away, so

"Peo Sjoblom" wrote:

> No need for multiple post within 10 minutes, see a possible answer to your
> previous post
>
> Regards,
>
> Peo Sjoblom
>
>
> "cyndi" <cyndi@discussions.microsoft.com> wrote in message
> news:96963619-4B3E-4BF5-A2C5-26D279AE5529@microsoft.com...
> > In excel 2003 I hit the dash key in a cell becusae it is null to me, then
> I
> > press the right arrow, and it will create a subtraction calculation, I
> know
> > if I hit the tab key it will not do this, but is there a way so I can use
> the
> > dash in one cell and then press the right arrow to move to the next column
> > without it caluculating?
> > any help would be great
> > thanks
>
>
>

[swatsp0p]

You could precede the dash with an apostrophe then hit the right arrow and only a dash will appear in the cell. Calculations that include this cell will treat it as zero.

HTH

[RagDyer]

Just a thought!

Would it help to change the direction after "Enter" to "Right"?

That way you could use <Enter> to exit the cell without calculating.

<Tools> <Options> <Edit> tab.


HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"cyndi" <cyndi@discussions.microsoft.com> wrote in message
news:96963619-4B3E-4BF5-A2C5-26D279AE5529@microsoft.com...
In excel 2003 I hit the dash key in a cell becusae it is null to me, then I
press the right arrow, and it will create a subtraction calculation, I know
if I hit the tab key it will not do this, but is there a way so I can use
the
dash in one cell and then press the right arrow to move to the next column
without it caluculating?
any help would be great
thanks