Accounting Troubleshooting

#### Appears in a Cell

If a number is too big to display in a cell, #### will appear instead. Make the column width wider. To do so:
1. Click anywhere in the column.
2. Choose Column Width from the FORMAT menu. If the menu item is grey, first choose Unprotect Document from the OPTIONS menu.
3. Type in a larger column width.
You may also see #### in a cell if a reference or name error has occurred (see the next item).

NOTE-- In 2000, MacNail was replaced by Goldenseal construction accounting software. Goldenseal is an integrated program that includes general accounting, job costing, payroll and project billing, plus estimating and other features.

#VALUE!, #REF! OR #NAME? Appears in a Cell

#REF appears in the Checkbook Ledger or in Labor, Material, or Subcontractor Logs when their link with the Master Index has been broken. Open the Master Index if it is not already open. You may need to choose Calculate Now to remove the old #REF values (see page 221).
This problem can also occur when a non-number is typed into a cell that should have a number value.

NOTE: Typing a space into a cell will cause an error. Excel can not see it like a blank cell, even though it looks like one to you! If you have a mysterious #VALUE error, click on and delete 'blank' cells in the row.

#REF errors can also be caused by improper insertions or deletions. Use *Add Rows and *Delete Rows only. Never use Excel 's Insert and Delete commands.

NOTE: Be very careful not to eliminate cells or formulas unintentionally if you make major structural changes in the MacNail construction accounting software. Be ready to revert to a previous saved version if errors start to appear.

To repair a numerical or reference error in the running total column of a Ledger:

1. Find the top row that has the error message or bad value.
2. Retype the deposit column for that row. If it should be blank, click in the cell and type the Backspace or Delete key.
3. Retype the payout column for that row. If it should be blank, click in the cell and type the Backspace or Delete key.
4. You may need to choose Calculate Now from the OPTIONS menu to show the corrected values.