All, Thank you for your responses. Michelle, thanks for listing out the steps. I was somewhat aware of this process, but felt there were too many clicks to make it worth the effort. BUT, you are correct, once I do it enough times, it becomes second nature. This is especially useful with large files.
Theo, This tool looks pretty cool and could be exactly what I am looking for. I looked over the website, but I cannot download it where I am currently working. Will need to give it a try when I am home. Have you used it? Can you confirm that it can retain the leading zeros without having to go through a bunch of steps? Also, is there a cost or is this freeware? Thanks, .ron On Wed, Jun 22, 2011 at 1:39 PM, Theo Fondse <[email protected]> wrote: > ** > > Hi Ron!**** > > ** ** > > You could try CSVed to see if it works for you:**** > > ** ** > > http://csved.sjfrancke.nl/index.html**** > > ** ** > > ** ** > > Best Regards,**** > > Theo**** > > ** ** > > Sent from my Black/Silver Personal Computer ....**** > > **** > > “Try not to become a person of success, but a person of value.” – Albert > Einstein**** > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Ron Tavares > *Sent:* 22 June 2011 15:31 > > *To:* [email protected] > *Subject:* Excel frustration with AIE and Data Imports**** > > ** ** > > ** **** > > Good Morning Listers,**** > > **** > > You how when you open a .csv file in Excel, Microsoft will do it's magic > and start changing the format of certain values? As an example, it will > drop the leading zeros form a value because it assumes it is numeric, (like > a serial number). So you have to fix the data, format the column as 'text' > and save the file. Then, the next time you open the file, the process > starts all over again. I know I can use notepad to edit, but that is a > pain.**** > > **** > > So I have two questions:**** > > 1) Is there a way to set a preference in Excel to say "Hey! don't do that!" > **** > > 2) Assuming the answer to question one is no, is there another tool out > there that works like Excel but is geared toward developer geeks? Sort of > like what Notepad is for Windows, except it would display the data in > column/row. I know I would really like a tool like that.**** > > **** > > Thanks,**** > > **** > > .ron**** > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ **** > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

