Dash or Minus sign shos as zero in formula

D

Darla

Please help! When I was typing a formula, my hand slipped accross the
keyboard. Since that moment, every time I type a formula that uses a minus
sign in front of a number, it changes the minus sign to a zero. This also
happens with a dash in Microsoft word with text. If there is a decimal point
before the minus sign, it works fine. We have tried reinstalling Excel and
reinstalling the keybord drivers and replacing the keyboard but nothing seems
to fix the problem. It is not the format either, that is the first thing I
checked. Here is an example
As Typed +235-157-25
As Displyed +2350157025
If you know what caused this, please let me know.
 
D

Dave Peterson

If all you did was hit random keys, then maybe you re-programmed your keyboard.

You may want to share the name/model of keyboard -- or look through some of the
documentation (online???) to determine how to fix this.

If by chance you changed
tools|Autocorrect options|autocorrect tab
and replaced - with 0
you can try to correct it under that same option.
 
D

Darla

That fixed it! Since I do accounting, it was causing such a big problem and
that never crossed anyones mind. I really appreciate your help, you just
made my job much easier.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top