Troubleshooting: Copy and paste from Excel – Invalid number format at column SubTotal, row 1

Question: When I copy from Excel and paste it on stock adjustment, message prompted “Invalid number format at column SubTotal, row 1” and I noticed that the sub total amount is not the same as the amount in Excel. Why?

Version: 1.8/ 1.9/ 2.0

Possible Reason:

The system can’t recognize symbol “( )” as negative value.

Solution:

Change all the Number cells (Qty, UnitCost, SubTotal) negative value format to “-1234.10”.

1) Highlight the whole cell, right click, and select Format Cells.

2) Click on Number, and choose the negative number format -1234.10, then click on OK.

3) Now, copy from the Excel and paste onto stock adjustment again, it is now successfully pasted, and the sub total figure is correct.

By: Benjamin 220713, Lay Swan 220727, P220728

Go to menu

AutoCount Accounting 2.0 & 2.1 AutoCount Accounting 2.0 What's New AutoCount Accounting 2.0 Help File AutoCount Accounting 2.0 FAQ (Application) AutoCount Accounting 2.0 FAQ (Troubleshoot) AutoCount Accounting 2.0 Others AutoCount Accounting 2.0 Release Note AutoCount Accounting 2.1 Release Note

AutoCount Accounting 1.8 / 1.9 AutoCount Accounting 1.8 FAQ (Application) AutoCount Accounting 1.8 FAQ (Troubleshoot) AutoCount Accounting 1.8 / 1.9 Release Note

AutoCount Payroll

AutoCount POS

AutoCount On The Go

AutoCount Accounting Plug-In Documentations