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.


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


AutoCount On The Go
AutoCount Accounting Plug-In Documentations