Excel File exported from Quickbooks does'nt register numbers as nu
 

Hello,

I am exporting a report from Quickbooks Point of Sale Pro 5.0 to Excel 2000
and trying to create a "sum of" calculation. The sum always comes to 0. It
is not registering the numbers as a number. However, if I do not use the
"sum of" button, and just put + (plus sign) and click each cell, it will add
the cells correctly. I have tried to use the Format Cells option but cannot
find a way to correct this problem. I have also noticed that when I go to
save it tells me that it is not the most recent version of Excel. I have
tried choosing to save to the most recent version or not and it doesn't make
a difference. I would love to be able to use the "sum of" button because I
am adding a great number of cells. Any suggestions would be greatly
appreciated.

Excel File exported from Quickbooks does'nt register numbers as nu
 

Format all to General.

Select an empty cell and copy.

Select the range to change and EditPaste SpecialAddOKEsc.

Your text numbers should now be real numbers.

The "not most recent version message" is generated when you open a file from an
earlier version of Excel.

Saving as the current version should eliminate that message when saving
thereafter.


Gord Dibben MS Excel MVP

On Tue, 13 May 2008 14:40:00 -0700, skoo wrote:

Hello,

I am exporting a report from Quickbooks Point of Sale Pro 5.0 to Excel 2000
and trying to create a "sum of" calculation. The sum always comes to 0. It
is not registering the numbers as a number. However, if I do not use the
"sum of" button, and just put + (plus sign) and click each cell, it will add
the cells correctly. I have tried to use the Format Cells option but cannot
find a way to correct this problem. I have also noticed that when I go to
save it tells me that it is not the most recent version of Excel. I have
tried choosing to save to the most recent version or not and it doesn't make
a difference. I would love to be able to use the "sum of" button because I
am adding a great number of cells. Any suggestions would be greatly
appreciated.