>From Excel2000 help file:
Display leading or trailing zeros in a number
You can use custom number formats to retain leading zeros in numbers that
you enter.
Select the cells you want to format.
On the Format menu, click Cells, and then click the Number tab.
In the Category list, click Custom.
In the Type box, edit the number format codes to create the format you want.
Editing a built-in format does not remove the format.
To display Use this code
12 as 00012 and 123 as 00123 00000
12 as 00012 and 123 as 000123 "000"#
123 as 0123 "0"#
8.9 as 8.900 #.000
.631 as 0.6 0.#
Notes
You can use number formats to change the appearance of numbers, including
dates and times, without changing the number behind the appearance.
Learn about using custom number formats for decimals and significant digits.
You can also use the & (ampersand) text operator to join, or concatenate,
two values to produce one continuous text value.
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 1 August 2001 6:13 PM
> To: Protel EDA Forum
> Subject: Re: [PEDA] Surface Mount Boards
>
>
> Dear All,
>
> When I edit foopprints' names in schematic in spreadsheet
> view all names
> like 0805, 0603 and etc. are loosing first 0. So synchronizer can find
> footprint 805.
> Can somebody help me to stop changing the cell by spreadsheet editor?
>
> Best regards,
> Yuri V.Potapoff
> technical expert
> Rodnik Software, Inc.
> 1 Nakhimovsky ave., bldg.1, Moscow, 113556 Russia
> Phones: +7 (095) 113-2688; +7 (095) 113-7001
> Fax: +7 (095) 317-9754
> E-mail: [EMAIL PROTECTED]
> http://www.rodnik.ru
>
>
>
>
> > ----------
> > From: Steve Wiseman[SMTP:[EMAIL PROTECTED]]
> > Sent: Tuesday, July 31, 2001 11:36:00 PM
> > To: Protel EDA Forum
> > Subject: Re: [PEDA] Surface Mount Boards
> > Auto forwarded by a Rule
> >
> >
> >
> > On Tue, 31 Jul 2001, Brad Velander wrote:
> >
> > > Norb,
> > > my comment would be 0603 is marginally most common over
> 0805s, but
> > > Mark could be correct.
> >
> > Weird values are slightly more available in 0805 than 0603 at the
> > moment. (where weird is E24 and above). I suspect the
> answer is, whatever
> > you can get that'll do the job. Me, I like stock Farenll parts...
> >
> > Steve
>
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* To post a message: mailto:[EMAIL PROTECTED]
*
* To leave this list visit:
* http://www.techservinc.com/protelusers/leave.html
* - or email -
* mailto:[EMAIL PROTECTED]?body=leave%20proteledaforum
*
* Contact the list manager:
* mailto:[EMAIL PROTECTED]
*
* Browse or Search previous postings:
* http://www.mail-archive.com/proteledaforum@techservinc.com
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
