I HAVE A VB APPLICATION THAT CREATES AN IMPORT CSV FILE FOR OUR
ACCOUNTS SOFTWARE - THIS INCUDES A BRANCH CODE FOR EXAMPLE "0609" -
WHEN OPENED IN EXCEL IT CONVERTS THIS TO "609" DROPPING THE LEADING
ZERO - HOW CAN I FORCE EXCEL TO USE THIS AS TEXT FROM THE VB EXPORT TO
CSV - I HAVE ALREADY TRIED PUTTING QUOTES ROUND IT BUT SAME OCCURS

Hello!
In order for Excel to interpret the 0609 (or any other number, of
course) as text, you have to add an apostrophe at the beginning, as
in:

'0609

You should have your application append the apostrophe before any
number that is supposed to be used as text.

You can find more information at this link:
Convert Excel Data Types
http://www.digdb.com/excel_add_ins/convert_data_type_text_general/


Google search terms
excel force text number
://www.google.com.ar/search?hl=es&q=excel+force+text+number&meta=


I hope this helps!
Best regards,
elmarto