Entering + or - into a cell

  • Thread starter Thread starter Big Bubba
  • Start date Start date
B

Big Bubba

Hopefully there is a simple answer to this. I have cells formatted as
general, though I have tried it text too, and would like to enter in a +
or -. Everytime I do it, it assumes I'm entering in a function and changes
it to +D2 (id I'm in the d2 cell.) How can I put in a + or - without this
problem?

Thanks for the help. Also, this in Excel 2000 and Excel XP. But, I think
the - problem doesn't occur in XP.

BR
 
Bubba

I suspect under tools>options>transition you have 'transition formula entry
checked'. The default behaviour should be that a leading minus is shown, but
a leading + gets stripped as it is a positive number and the + is
superfluous

you could set a custom format of

+0;-0;0

Under format>cells...>number>custom

This way any number with no sign will have a + put in front, anything that
results in a negative a - and zeroes will be unaffected

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Bonjour, *Big Bubba*
J'ai lu ton post (e-mail address removed)
avec le plus grand intéret :

Did you try '+ or '-

Best regards
Patrick
 
Back
Top