Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel formula not working
Hello and thanks in advance.....
I have a user who has crated a spreadsheet & the formula has been entered correctly but is not showing the true results. The formula is; =max(A1:A162) There are enteries in column A and I am expecting the figure to show as 350. This is actually showing as 100 - a figure which is also in column A I have re inserted the formula - this does not work. I have also put the formula in a completely different cell but again this does not work. If I over type the data in all the cells the formula works however I cannot tell the user to retype thousands of enteries. I have checked the formatting of the spreadsheet, this all looks ok. Also have checked the tools & options, this is all ok (calculation is set to automatic). Any ideas why this happened but more importantly is there a easy fix to correct this? Thanks in advance James |
#2
|
|||
|
|||
The formula is probably not giving you the correct answer as you see it because
the "numbers" you are looking at may not all be entered as numbers but as text. This can be easily fixed by entering 0 in an empty cell, Edit | Copy, select the range where these numbers are, Edit | Paste Special Add HTH "James" wrote in message ... : Hello and thanks in advance..... : : I have a user who has crated a spreadsheet & the formula has been entered : correctly but is not showing the true results. : The formula is; : : =max(A1:A162) : : There are enteries in column A and I am expecting the figure to show as 350. : This is actually showing as 100 - a figure which is also in column A : I have re inserted the formula - this does not work. I have also put the : formula in a completely different cell but again this does not work. : : If I over type the data in all the cells the formula works however I cannot : tell the user to retype thousands of enteries. : : I have checked the formatting of the spreadsheet, this all looks ok. Also : have checked the tools & options, this is all ok (calculation is set to : automatic). : : Any ideas why this happened but more importantly is there a easy fix to : correct this? : : Thanks in advance : : James : |
#3
|
|||
|
|||
Lady Layla,
Thanks for the advice but this did not work, anything else I can try? "Lady Layla" wrote: The formula is probably not giving you the correct answer as you see it because the "numbers" you are looking at may not all be entered as numbers but as text. This can be easily fixed by entering 0 in an empty cell, Edit | Copy, select the range where these numbers are, Edit | Paste Special Add HTH "James" wrote in message ... : Hello and thanks in advance..... : : I have a user who has crated a spreadsheet & the formula has been entered : correctly but is not showing the true results. : The formula is; : : =max(A1:A162) : : There are enteries in column A and I am expecting the figure to show as 350. : This is actually showing as 100 - a figure which is also in column A : I have re inserted the formula - this does not work. I have also put the : formula in a completely different cell but again this does not work. : : If I over type the data in all the cells the formula works however I cannot : tell the user to retype thousands of enteries. : : I have checked the formatting of the spreadsheet, this all looks ok. Also : have checked the tools & options, this is all ok (calculation is set to : automatic). : : Any ideas why this happened but more importantly is there a easy fix to : correct this? : : Thanks in advance : : James : |
#4
|
|||
|
|||
James
If Layla's steps do not work, perhaps you have a non-breaking space in the cell. Where does the data come from. A web site or similar? Try editreplace what: Hold ALT key and type 0160(on the numpad) with: nothing Gord Dibben Excel MVP On Wed, 2 Mar 2005 07:33:07 -0800, "James" wrote: Lady Layla, Thanks for the advice but this did not work, anything else I can try? "Lady Layla" wrote: The formula is probably not giving you the correct answer as you see it because the "numbers" you are looking at may not all be entered as numbers but as text. This can be easily fixed by entering 0 in an empty cell, Edit | Copy, select the range where these numbers are, Edit | Paste Special Add HTH "James" wrote in message ... : Hello and thanks in advance..... : : I have a user who has crated a spreadsheet & the formula has been entered : correctly but is not showing the true results. : The formula is; : : =max(A1:A162) : : There are enteries in column A and I am expecting the figure to show as 350. : This is actually showing as 100 - a figure which is also in column A : I have re inserted the formula - this does not work. I have also put the : formula in a completely different cell but again this does not work. : : If I over type the data in all the cells the formula works however I cannot : tell the user to retype thousands of enteries. : : I have checked the formatting of the spreadsheet, this all looks ok. Also : have checked the tools & options, this is all ok (calculation is set to : automatic). : : Any ideas why this happened but more importantly is there a easy fix to : correct this? : : Thanks in advance : : James : |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
Polynimial trandline formula | Charts and Charting in Excel | |||
Excel: Formula worked last week but now stoppped working. | Excel Worksheet Functions | |||
Excel formula not working | Excel Discussion (Misc queries) |