export to ccsv problem

hi all

I am exporting a customer table to a csv the problem is with the telephone column, in the db it is +442085390123 but in the csv files it is showing as 4.42086E+13

I have tried on converting it on export but i am still having problems ..any surgestions?

Kind Regards

rich

Are you viewing in Excel or similar?

If so, it is because the app is asuming that the value is a numeric. The data in the .csv file is probably correct, can you view it in Notepad?