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

From AutoCount Resource Center

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.


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 1.8 / 1.9
AutoCount Payroll
AutoCount POS

AutoCount On The Go
AutoCount Accounting Plug-In Documentations