Excel calculation problem

RobM · Apr 15th, 2002, 05:25 AM

I am having trouble with Excel 2000. When I enter a simple formula in a cell the answer is incorrect. For example 5+5 equals 192086.
Ive tried to reinstall MS office twice with no help.

Thanks

Rob M

christal · Apr 15th, 2002, 05:30 AM

This maybe an obvious question, but did you check the formatting of the cell?

RobM · Apr 15th, 2002, 08:03 AM

I was running a spreadsheet to do some complex calculations. I noticed alot of errors on the sheet. I opened a new file to test and noticed that it was not calculating correctly. This normally works at my office. This is the first time I tried to use Excel at home.

Chris Davison · Apr 15th, 2002, 01:31 PM

=5+5

is 10

(I can see you're impressed so far)

as Christal mentioned, could it be formatting ?

I formatted 10 as custom : yyyymd and it gave 1900110, which is close

did you actually type 5+5 or were they linked to other cells with maybe rounding applied ?

Apr 15th, 2002, 01:31 PM	#4
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	=5+5 is 10 (I can see you're impressed so far) as Christal mentioned, could it be formatting ? I formatted 10 as custom : yyyymd and it gave 1900110, which is close did you actually type 5+5 or were they linked to other cells with maybe rounding applied ? __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 15th, 2002, 05:25 AM	#1
RobM New Member Join Date: Apr 2002 Location: Montreal Posts: 2	I am having trouble with Excel 2000. When I enter a simple formula in a cell the answer is incorrect. For example 5+5 equals 192086. Ive tried to reinstall MS office twice with no help. Thanks Rob M

Apr 15th, 2002, 05:30 AM	#2
christal New Member Join Date: Apr 2002 Posts: 45	This maybe an obvious question, but did you check the formatting of the cell?

Apr 15th, 2002, 08:03 AM	#3
RobM New Member Join Date: Apr 2002 Location: Montreal Posts: 2	I was running a spreadsheet to do some complex calculations. I noticed alot of errors on the sheet. I opened a new file to test and noticed that it was not calculating correctly. This normally works at my office. This is the first time I tried to use Excel at home.