I am having a problem with Excel removing any leading zeros when I open
values from a CSV file.

The file contains the leading zeros when I open it in notepad, but when I do
so in Excel these are removed. What can I do so I can open the CSV file in
Excel but still have the leading zeros?

Paul Smith

Open it as text file and use the text parsing options, you will need to
change the file extension to .txt otherwise Excel will override you text
import options.

"Paul W Smith" wrote in message
...
I am having a problem with Excel removing any leading zeros when I open
values from a CSV file.

The file contains the leading zeros when I open it in notepad, but when I
do
so in Excel these are removed. What can I do so I can open the CSV file
in
Excel but still have the leading zeros?

Paul Smith






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

You'll have to import it as a TEXT field.

In order to ensure you'll get the text to column wizard
you'll need to rename the .CSV file to .TXT prior to opening.

Else
download the excellent free "asap utilities" from www.asaputilities.com
among it's many features it has proper CSV conversion options.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Paul W Smith" wrote:

I am having a problem with Excel removing any leading zeros when I
open values from a CSV file.

The file contains the leading zeros when I open it in notepad, but
when I do so in Excel these are removed. What can I do so I can open
the CSV file in Excel but still have the leading zeros?

Paul Smith