I have an issue when taking an Excel 2003 sheet and exporting to a CSV file.
I know the steps and all works fine but.... how Excel creates the .csv file
if there is a 0 in a cell of a row instead of putting the 0 in the .csv file
it just leaves it blank.
e.g.
Row 1: 1 5 0 6 7
CSV is: 1,5,,6,7
I need: 1,5,0,6,7
Is there a way to force Excel to include that 0 vs. leave it blank and go on
to the next column in the row?
Thanks!
-Richard
Jim Rech - 30 Jun 2008 14:13 GMT
In my test I got the zero in the CSV file:
1,2,0,3,4

Signature
Jim
|I have an issue when taking an Excel 2003 sheet and exporting to a CSV file.
| I know the steps and all works fine but.... how Excel creates the .csv file
[quoted text clipped - 15 lines]
|
| -Richard
Dave Peterson - 30 Jun 2008 14:39 GMT
How are you creating the CSV file?
Do you use File|SaveAs or are you running a macro?
> I have an issue when taking an Excel 2003 sheet and exporting to a CSV file.
> I know the steps and all works fine but.... how Excel creates the .csv file
[quoted text clipped - 15 lines]
>
> -Richard

Signature
Dave Peterson