I think it will work if you cut and paste the CSV file, then do "text to columns", which lets you format the fields on the way in.
-dn > -----Original Message----- > From: Bryn Wolfe [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 20, 2002 07:43 > To: Protel EDA Forum > Subject: Re: [PEDA] Using Client Spreadsheets to update schematics > > > The lopping off of leading zeros is a feature of Excel. It > has nothing > to do with Protel IMHO. So unless Protel can export in an > Excel format > and set the nature of the columns for us (now that'd be nice), I say > it's not a bug, but just an unimplemented feature THAT PROTEL SHOULD > SERIOUSLY CONSIDER ADDING! That wasn't yelling, it was > emphasizing with > vigor to the "lurkers" among us. > > And, in case anybody actually reads these messages, I like Protel. > Protel is to OrCAD as SolidWorks is to AutoCAD (for those > mechies among > us). Protel has put more polish on their product to improve the UI > instead of sticking with the often obtuse OrCAD interface. > Unfortunately, polish doesn't make bugs go away. They'll > never get all > the bugs out, it's probabilistically impossible. > > Bryn > > [EMAIL PROTECTED] wrote: > > >In a message dated 2/19/2002 4:14:37 PM Eastern Standard Time, > >[EMAIL PROTECTED] writes: > > > > > >>I tried adding leading apostrophe & zero on footprint > ('0603), in client > >>spreadsheet, and File | Update sets the footprint field > without the leading > >>apostrophe. Or is the problem that there's no automatic > way to know which > >>items had zeros removed? > >> > >>If there are only a couple footprints like this, you could > just do global > >>edit when you're done with update, 805=>0805, etc. > >> > > > >That's what I did. Still, it seems pretty kludgy, for a > "feature" which > >Protel touts in their marketing literature. > > > >Steve Hendrix > > > > > > -- > Name : Bryn Wolfe > Title : Robotics Engineer > Dept : Texas Robotics & Automation Center (TRACLabs) > Company: Metrica, Inc > Addr : 1012 Hercules Drive > Houston, TX 77058-2722 > Voice : 281-461-7886 > NASA : n/a > FAX : 281-461-9550 > Web : http://www.traclabs.com > Email : mailto:[EMAIL PROTECTED] or > mailto:[EMAIL PROTECTED] > > > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/[email protected] * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
