Export to CSV Issue

[Richard K]

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]

In my test I got the zero in the CSV file:

1,2,0,3,4

--
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
| 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
|
|

 

[Dave Peterson]

How are you creating the CSV file?

Do you use File|SaveAs or are you running a macro?