Importing Budget into Pastel Express11

[Tanya Kruger]

Hi, I want to import budgets into pastel.
When i import the .csv file, it says the following: Line1: Account does not excist.
The company has 20 branches.
If i export the budget form pastel to get the layout and the format, it is as follows on the .csv:
"0800154"
"0800701"
but when i open it in excel it is as follows:
0800154
0800701

I have added the '0' infront but when i save it as .csv, the '0' is going away.
Will love to get help on this.

Tanya

[Neville Bailey]

That's one of the irritating things about CSV files when you open them in Excel - all leading zeroes disappear!

When you open the CSV file, insert the zero in front of the code, but with a single quotation mark in front of the zero, i.e. '0 not only 0

Then save the CSV file but import it before you reopen it again, otherwise you are back to square one again.

[Tanya Kruger]

Thank you, was not sure if I can do that because it had the " infront.