Exporting Data from MAS500 into Excel problem

[Guest]

Has anyone ever exported data from MAS500 into Excel, and been able to write
formulas in the worksheet that worked? MAS500 has a feature to export to an
Excel worksheet, but once I have the data in Excel and write the formula, I'm
not getting the correct answer. I have tested the formula in another
worksheet, with data that I put into the cells, and I get the correct answer.
These are very simple formulas such as =SUM(AJ39-SUM(AK39:AL39)*H39). Any
ideas? Calculate is on in the options tab. I've replaced the data with
values I've put in, and the answer does not change as it should. Tried
hitting F9 to calculate, no change.

 

[Peo Sjoblom]

See if the values are text.

Select a cell, format it as general then put this formula there

=ISNUMBER(cell)

and check all cells in question, if they return TRUE it is OK if FALSE then
there is your answer.
Also make sure calculations are set to automatic under
tools>options>calculation

 

[Gord Dibben]

If the data is formatted as text................

Format all to General.

Copy an empty cell.

Select the data range and Edit>Paste Special>Add>OK>Esc.


Gord Dibben MS Excel MVP

 

[Guest]

Peo, thanks for the suggestion. Value is formatted as general, checked using
the isnumber(cell), and return is true. Still stuck.

Thanks

Ken

 

[Guest]

Gord, formatting is not the problem, I have checked that.

Thanks

Ken