Microsoft KB Archive/922102

= You cannot run calculations in Excel after exporting reports from Small Business Accounting 2006, from Accounting Professional 2007, or from Accounting Express 2007 =

Article ID: 922102

Article Last Modified on 2/8/2007

-

APPLIES TO


 * Microsoft Office Accounting Professional 2007
 * Microsoft Office Accounting Express 2007
 * Microsoft Office Small Business Accounting 2006
 * Microsoft Office Small Business Management Edition 2006

-





SYMPTOMS
You export reports from Microsoft Office Small Business Accounting 2006, from Microsoft Office Accounting Professional 2007, or from Microsoft Office Accounting Express 2007 to Microsoft Excel. Then, you enter calculations in a cell in Excel. When you do this, Excel does not run the calculations that you entered. Instead, Excel displays the text of the calculations.



CAUSE
This problem occurs because the format of the cell in which you entered calculations is not set to a numeric value.



RESOLUTION
To resolve this problem, correctly format the cell in which you want to enter calculations. To do this, follow these steps:
 * 1) In Excel, right-click the cell in which you want to enter calculations. Then, click Format Cells.
 * 2) On the Number tab, select a category that accepts number formats. For example, you can select Number or Currency.
 * 3) Click OK.
 * 4) Enter the calculations into the cell that you just formatted.

Note Excel will run the calculations.



Steps to reproduce the problem

 * 1) In Small Business Accounting 2006, Accounting Professional 2007, or Accounting Express 2007, point to Company and Financial on the Reports menu, and then click Trial Balance.
 * 2) On the toolbar, click Export to Excel.
 * 3) In Excel, enter your calculations in a cell, such as A8.

Keywords: kbtshoot kbprb kbmbsmigrate KB922102

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.