*******************************************************
Todays forums are sponsored by Ian Martin Limited
Engineering/Technical Placement Specialists
www.ianmartin.com
*******************************************************

At 08:25 AM 10/5/01 -0700, Brooks,Bill wrote:
>I have had trouble with the spreadsheet tools - they always drop leading
>zeros... which is a bother, because we use part numbers with leading
>zeros... Guess there's always a fly in the ointment... It makes the tool
>useless to me.
>- Bill Brooks

A common problem with spreadsheet programs....

Edit all your part numbers to prefix a non-numeric, non-arithmetic 
operation character to them. You should be able to do this globally. An 
apostrophe might do fine, check it out; you could take it out later if you 
must.

[EMAIL PROTECTED]
Abdulrahman Lomax
Easthampton, Massachusetts USA

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* 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/proteledaforum@techservinc.com
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Reply via email to