export data form Excel to CSV file

[serg]

I need to export data from Excel to CSV file. But problem is that when I have format cells - decimal places set to 2 and have value in this cell for example 1.4195566, excel shows me 1.42. So now when I export to CSV file the value is 1.42, but I need 1.1495566.
The decimal place can't be set manually in my case, so I need some kind of VBA script to save CSV file.

thanx.

[Leith Ross]

Hi Serg,

I would copy the worksheet, remove the formats on the copy and save as an Excel.csv file. Unless you are facing other issues with this worksheet, this would be the easiest and quickest solution.

Hope this helps,
Leith Ross