Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Excel XLS file to Quickbooks QIF file format | Excel Discussion (Misc queries) | |||
Time/ Number format on excel file exported from Access | Excel Discussion (Misc queries) | |||
Excel crashes on opening exported file; formatting weird afterwards | Excel Discussion (Misc queries) | |||
Can you import a Quickbooks file into excel | Excel Discussion (Misc queries) | |||
Exporting From Quickbooks-not formatting numbers | Excel Discussion (Misc queries) |