CSV Export Question

  • Thread starter Thread starter Richard K
  • Start date Start date
R

Richard K

I have an Excel 2003 spreadsheet that I am saving as a .csv file (saves the
current sheet). All works fine with the exception of cells that have 0 as a
value. In those cases instead of saving in the format of ,0, it saves in
the format of ,, (Basically it won't save the 0 but leaves it blank and
just goes to the , to indicate the next column.

Is there a way I can force Excel to save the 0?

Thanks!

-Richard K
 
There are multiple different csv options... the one you want is "CSV
(Comma delimited)(*.csv)"

not "CSV (Macintosh)(*.csv)" or "CSV (MS-DOS)(*.csv)" which will be
slightly different

I tested it on my computer just now and it showed up exactly as you'd
expect

The only other possibility is that you've got a weird formatting
applied to the cell... for example

take the formula =if(a1=0,"",b1/a1)
that's a common thing for people to do to eliminate #DIV/0! errors. If
you apply custom formatting to that cell that looks like this
[0.00;-0.00;"Zero";"0"] then it will display that cell as a "0" but
the cells' contents will actually be an empty string... that might get
CSVd to a ,, by excel (I'm not certain)

good luck
 
Back
Top