I am attempting to import budget data into Ledger 9.0B and am having no luck. I have tried .csv and .xls files but neither are working. It looks as though the data is importing but the budgets are just zero. I am using Excel 2007 and have saved both an .xls file and .csv file, neither are importing properly. I have tried ensuring the account and dept are text and the period budget data is number formatting but the .csv will not save this formatting, it turns it all to 'general'. Maybe the formatting is the issue but it won't stick so I am not sure what to do. I have tried a number of things to no avail.

Ready to pull my hair out... I thought this would be easier than manual entry but it is turning into a big time waster. Please help!