General Ledger - Spreadsheet Import - Error at Account No, starting with Zero

SOLVED

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