Export to .csv Losing leading zeros

[nigelh]

Hi,

I'm exporting a table to a .csv file. The table contains phone numbers with a data type of 'text'. When I look at the csv file strange things are happening
e.g Phone number 08705329877 appears as 8.7E+09 if I expand the width of the field in the csv it changes to 8705329877 (miising the leading zero).

Can anyone help?

Cheers,

Nigel

 

[Brutal]

Dufuss in da house

Sorry Chaps,
Please explain how to do this to an imbasile,
I have the table and now ran simple query wizard, got all the required fields, please where and how do I enter "Select format.........." thingy.
Need to have done this by the morning uk time -in deep trouble

Fanks

Brutal

 

[Brutal]

Ta Very Much

Thankyou
I cannot thank the people on this forum enough for all the help thay give me - I am such a dunce, You all get me out of so many scrapes, especially you Pat.

Thanks Again

Brutal