Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problem in Excel with numeric keypad and + sign
That's a good question!- isfco
- Post #10
- Forum: Microsoft: Office
-
Problem in Excel with numeric keypad and + sign
My first post said what I meant what I type and what I see are not the same thing. There are no + signs between the nines until Excel 'flips' them to =, that is.- isfco
- Post #8
- Forum: Microsoft: Office
-
Problem in Excel with numeric keypad and + sign
In the cell I type =9+9+9+9 and then hit enter. As I am typing the + signs between the nines I can see them 'changing before my eyes' to equals signs. So obviously when I hit enter the cell displays FALSE. It is false. What parameter can I alter to stop the + signs from changing as I type them...- isfco
- Post #7
- Forum: Microsoft: Office
-
Problem in Excel with numeric keypad and + sign
Neither one is working, unfortunately. Both = and + work on all the other Excel systems but not on this one professional's computer. The cell just displas FALSE when we use the = first. We get an error when we type the + like you could do back in Lotus123. I sent her my file that was working...- isfco
- Post #4
- Forum: Microsoft: Office
-
Problem in Excel with numeric keypad and + sign
In any cell in a new or existing spreadsheet, If you add 9+9+9 and hit enter, what you see occur is: 9=9=9 and the cell displays 'FALSE' instead of 27 which is what we generally are accustomed to seeing in Excel. Thanks for any assistance you can offer. We did try changing transition formula...- isfco
- Thread
- Replies: 9
- Forum: Microsoft: Office
-
Prevent program modifications
Thank you Skip, but all of the accountants/CPA's here really want their set for the 'program' not individual files. They use between 15 and 20 workbooks a day and setting each one, with hundreds to get to overall, is not an attractive prospect. It seems odd to me that there is not a file (like...- isfco
- Post #3
- Forum: Microsoft: Office
-
Prevent program modifications
Is there a file to make read-only or another way to prevent someone's Excel settings/options/configuration from being modified once they have it set exactly the way they like it? I have a couple of bosses who are frustrated that when they receive spreadsheets from others that they open, and when...- isfco
- Thread
- Replies: 2
- Forum: Microsoft: Office
-
format changes from accounting to fraction to my frustration!
Sorry, but can't do that. Accountants have always used the + sign on the numeric keypad for starting the formula entry. It's been that way since Excel for Windows came about.- isfco
- Post #3
- Forum: Microsoft: Office
-
format changes from accounting to fraction to my frustration!
If I enter +1200/200 and hit enter in a cell. Then go format the same cell as 'accounting' (2,$) Then I go back to the cell and enter +1400/2000 and hit enter the cell format changes to fraction automatically. This is a new manifestation and I don't know what has caused the change. Please assist...- isfco
- Thread
- Replies: 3
- Forum: Microsoft: Office
