If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Strange error with basic divide function
I am using Excel 2000 and if I enter a formula that uses the / key to
perform a divide function, I get a "formula you typed contains an error" message. This will happen with basic =4/5 or with cell references. If I open an existing sheet that has a divide function, it will work until I make any change to the cell. I am not using any Lotus compatibility, or other strange settings and I have performed a Repair installation of the software. Ideas? Brent |
#2
|
|||
|
|||
Strange error with basic divide function
This is probably not it, but the only thing I could think of was what would
happen if someone made an autocorrect entry for / (to be changed to, for instance !) I just tried it and then typed =4/5 and I did get the error message. However, if this was the problem, you should see the ! in the cell (=4!5) BTW, I immediately deleted the autocorrect after the experiment. -- Kevin Vaughn "Brent" wrote: I am using Excel 2000 and if I enter a formula that uses the / key to perform a divide function, I get a "formula you typed contains an error" message. This will happen with basic =4/5 or with cell references. If I open an existing sheet that has a divide function, it will work until I make any change to the cell. I am not using any Lotus compatibility, or other strange settings and I have performed a Repair installation of the software. Ideas? Brent |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Function 2 divide a number (ie $1.00) by % (ie 25%) to = ($4.00)? | Gonecoastal1 | Worksheet Functions | 12 | March 18th, 2006 03:27 AM |
determine if Excel is open | geebee | General Discussion | 11 | January 20th, 2006 09:25 PM |
SPELL CURRENCY FUNCTION | Rajesh | Using Forms | 1 | October 1st, 2005 11:04 PM |
Attaching Code | DS | General Discussion | 2 | August 22nd, 2005 11:21 PM |
dlookup documentation? | Fredrated | New Users | 1 | May 19th, 2005 11:10 PM |