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"

Reply via email to