A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Strange error with basic divide function



 
 
Thread Tools Display Modes
  #1  
Old June 28th, 2006, 12:52 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default 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  
Old June 28th, 2006, 09:20 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 01:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.