I am attempting to upload a csv file but when saving I lose my initial zero
in my spreadsheet due to the conversion to csv. I have tried EVERYTHING that
I have read on these discussion groups and to no avail...the zero is dropped
as soon as I save to csv. I have checked in notepad (zero is there),
converted to text, blah blah - but zero is dropped every time I convert to
csv.

"LisaG" wrote in message
...
I am attempting to upload a csv file but when saving I lose my initial zero
in my spreadsheet due to the conversion to csv. I have tried EVERYTHING
that
I have read on these discussion groups and to no avail...the zero is
dropped
as soon as I save to csv. I have checked in notepad (zero is there),
converted to text, blah blah - but zero is dropped every time I convert to
csv.

Are you talking about cells that should contain ONLY a zero, or are you
losing leading zeros, so that a number like "00456" becomes "456"?

Leads with a zero (7 digit number). I have tried custom formatting as well.
It is gone as soon as I convert to csv.

"Doug Kanter" wrote:


"LisaG" wrote in message
...
I am attempting to upload a csv file but when saving I lose my initial zero
in my spreadsheet due to the conversion to csv. I have tried EVERYTHING
that
I have read on these discussion groups and to no avail...the zero is
dropped
as soon as I save to csv. I have checked in notepad (zero is there),
converted to text, blah blah - but zero is dropped every time I convert to
csv.

Are you talking about cells that should contain ONLY a zero, or are you
losing leading zeros, so that a number like "00456" becomes "456"?

I have also changed the xls file to txt and imported into Excel formating
that zero digit column as text but again as soon as I save in csv format, the
zero is gone. I have to have this done by Monday and I am fed up.

"LisaG" wrote:

Leads with a zero (7 digit number). I have tried custom formatting as well.
It is gone as soon as I convert to csv.

"Doug Kanter" wrote:


"LisaG" wrote in message
...
I am attempting to upload a csv file but when saving I lose my initial zero
in my spreadsheet due to the conversion to csv. I have tried EVERYTHING
that
I have read on these discussion groups and to no avail...the zero is
dropped
as soon as I save to csv. I have checked in notepad (zero is there),
converted to text, blah blah - but zero is dropped every time I convert to
csv.

Are you talking about cells that should contain ONLY a zero, or are you
losing leading zeros, so that a number like "00456" becomes "456"?

It is when you open the csv file in excel it gets changed so the csv file
itself should have the leading zeros
if you are sending it to another program

--
Regards,

Peo Sjoblom

(No private emails please)


"LisaG" wrote in message
...
I have also changed the xls file to txt and imported into Excel formating
that zero digit column as text but again as soon as I save in csv format,
the
zero is gone. I have to have this done by Monday and I am fed up.

"LisaG" wrote:

Leads with a zero (7 digit number). I have tried custom formatting as
well.
It is gone as soon as I convert to csv.

"Doug Kanter" wrote:


"LisaG" wrote in message
...
I am attempting to upload a csv file but when saving I lose my initial
zero
in my spreadsheet due to the conversion to csv. I have tried
EVERYTHING
that
I have read on these discussion groups and to no avail...the zero is
dropped
as soon as I save to csv. I have checked in notepad (zero is there),
converted to text, blah blah - but zero is dropped every time I
convert to
csv.

Are you talking about cells that should contain ONLY a zero, or are you
losing leading zeros, so that a number like "00456" becomes "456"?

Thanks but no it isn't working - I am trying to upload this file to a student
information system and the SIS does not recognize the zeros even though I
know (and you know) they are there as they are viewable in Notepad. Any
other suggestions?

Lisa

"Peo Sjoblom" wrote:

It is when you open the csv file in excel it gets changed so the csv file
itself should have the leading zeros
if you are sending it to another program

--
Regards,

Peo Sjoblom

(No private emails please)


"LisaG" wrote in message
...
I have also changed the xls file to txt and imported into Excel formating
that zero digit column as text but again as soon as I save in csv format,
the
zero is gone. I have to have this done by Monday and I am fed up.

"LisaG" wrote:

Leads with a zero (7 digit number). I have tried custom formatting as
well.
It is gone as soon as I convert to csv.

"Doug Kanter" wrote:


"LisaG" wrote in message
...
I am attempting to upload a csv file but when saving I lose my initial
zero
in my spreadsheet due to the conversion to csv. I have tried
EVERYTHING
that
I have read on these discussion groups and to no avail...the zero is
dropped
as soon as I save to csv. I have checked in notepad (zero is there),
converted to text, blah blah - but zero is dropped every time I
convert to
csv.

Are you talking about cells that should contain ONLY a zero, or are you
losing leading zeros, so that a number like "00456" becomes "456"?