I am having trouble with my Spreadsheet upload to General Ledger in Sage 300. When the Account no.'s are in Number format in Excel Spreadsheet, Accpac imports fine. But when I have Account No.'s starting with a "0", Accpac stops importing. To keep "0" at the beginning of the number I either had to change the cell format to Text or add apostrophe at the beginning of that Account No. And Accpac tells me Account No. cells can not be empty. So can not get this to work.
Any advice and tips would be much appreciated.
Thanks
U Wang