I need to retain leading zeros in a column of numbers, such as 001001001.
The 00 must be retained when a csv file is opened.

How?

Format the cells as text or else as a custom format, say 000000000

Dave
--
Brevity is the soul of wit.


"vontzy" wrote:

I need to retain leading zeros in a column of numbers, such as 001001001.
The 00 must be retained when a csv file is opened.

How?

Rename your csv to .txt, use the wizard to open the txt file in Excel, and
format the column to text before you finish the import.
--
David Biddulph

"vontzy" wrote in message
...
I need to retain leading zeros in a column of numbers, such as 001001001.
The 00 must be retained when a csv file is opened.

How?

Thanks Dave! I found this solution just after I posted this. I still thank
you for your reply! I only wish this would work when I open the csv file.
As you may know I must first open the file, then change the Cell Format, and
then save it as an XLS File. If I save it as CSV it loses the Cell Format.
I guess this can't be done automatcally when the File is opened. The
original Text File I am opening with Excel has the leading 00's, they are
just lost. Thanks again.

Vontzy


"Dave F" wrote:

Format the cells as text or else as a custom format, say 000000000

Dave
--
Brevity is the soul of wit.


"vontzy" wrote:

I need to retain leading zeros in a column of numbers, such as 001001001.
The 00 must be retained when a csv file is opened.

How?

Dave,

Thanks for the response but surprisingly this does not work. My File is in
Text Format, with the leading 00's in the Cell but when I open it with Excel
it automatically drops them. When I use the Wizard to try to get the 00's
back it simply shifts the Cell Data to the left.

I had stumbled onto the solution that Dave F. had provided just after I
posted this and it does work, althougth not when the File is opened from the
Text File.

Thanks again for your Post.

Vontzy

"David Biddulph" wrote:

Rename your csv to .txt, use the wizard to open the txt file in Excel, and
format the column to text before you finish the import.
--
David Biddulph

"vontzy" wrote in message
...
I need to retain leading zeros in a column of numbers, such as 001001001.
The 00 must be retained when a csv file is opened.

How?

Actually, the leading 0's aren't lost when you save to your .CSV file. You can
open that file in NotePad and see them there.

They are lost after you re-open the file in excel.

vontzy wrote:

Thanks Dave! I found this solution just after I posted this. I still thank
you for your reply! I only wish this would work when I open the csv file.
As you may know I must first open the file, then change the Cell Format, and
then save it as an XLS File. If I save it as CSV it loses the Cell Format.
I guess this can't be done automatcally when the File is opened. The
original Text File I am opening with Excel has the leading 00's, they are
just lost. Thanks again.

Vontzy


"Dave F" wrote:

Format the cells as text or else as a custom format, say 000000000

Dave
--
Brevity is the soul of wit.


"vontzy" wrote:

I need to retain leading zeros in a column of numbers, such as 001001001.
The 00 must be retained when a csv file is opened.

How?

--

Dave Peterson

It *does* work, provided that you format the column to text WITHIN THE
WIZARD, BEFORE YOU FINISH THE IMPORT. If you allow it to import as General
or Number, and then try to change to Text afterwards, it's too late, as you
found.
--
David Biddulph

"vontzy" wrote in message
...
Dave,

Thanks for the response but surprisingly this does not work. My File is
in
Text Format, with the leading 00's in the Cell but when I open it with
Excel
it automatically drops them. When I use the Wizard to try to get the 00's
back it simply shifts the Cell Data to the left.

I had stumbled onto the solution that Dave F. had provided just after I
posted this and it does work, althougth not when the File is opened from
the
Text File.

Thanks again for your Post.

Vontzy

"David Biddulph" wrote:

Rename your csv to .txt, use the wizard to open the txt file in Excel,
and
format the column to text before you finish the import.
--
David Biddulph

"vontzy" wrote in message
...
I need to retain leading zeros in a column of numbers, such as
001001001.
The 00 must be retained when a csv file is opened.

How?