LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10
Default Dash or Minus sign shos as zero in formula

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
minus sign tom mcdonald Excel Worksheet Functions 1 April 19th 06 09:58 AM
plus and minus sign in cells ivoryhunter Excel Worksheet Functions 3 April 10th 06 01:28 PM
understanding dash dash in a excel formula ldebner Excel Worksheet Functions 2 October 31st 05 01:47 PM
I want to display the minus sign ED New Users to Excel 7 October 27th 05 10:06 PM
moving minus sign from right to left GEORGIA Excel Worksheet Functions 3 April 29th 05 02:54 PM


All times are GMT +1. The time now is 12:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"