2007 excell
I have data of hundrit of serial numbers of equipment that some start as ZERO, some as other number, some as letter. I don't want top change it to text because I need to sort it by number. How can I show the 0 as 1st number in the serial numbers I need to (to rest I don't want to add zero). To me 0 has a meaning because equipment that is 01234 is a different equipment from equipment 1234 (two different pcs).
Please help.
Format the cells as 00000 (enough zeros to put the leading zero in cells that need it).
If the length of the numbers that need leading zeros are not the same, you have no choice but to format the cells as text.
Last edited by shg; 01-11-2011 at 05:43 PM.
Entia non sunt multiplicanda sine necessitate
Right click on a cell, give the cell the format '000000000000 in the personalized category. Use the number of digits you have in your codes as I use 12 digits upc's. So it's just an added coma, that's it. As long as your upc's have the same number of digits.
The apostrophe will disappear.
Reproduce the format (using the paintbrush) to your barcode column and that should do it.
Good luck
PS. You can space them - this is how we do it: '0 00000 00000 0
Last edited by Eddie Lives On; 01-11-2011 at 05:55 PM. Reason: Added PS & apostrophe
Re: 0 as first number (cannot be text and # lenghts very)
--------------------------------------------------------------------------------------------------------------------------------Originally Posted by shg
Are there any disadventages to format all the cells in the column as TEXT?
A serial number / part number with leading zeros is, by definition, text. With consistent downstream processing, there are no disadvantages.
Re: 0 as first number (cannot be text and # lenghts very)
--------------------------------------------------------------------------------------------------
When you say "With consistent downstream processing" do you mean as long as all the cells in that one calumn are formated the same, here as Text?
Yes, exactly.
Make the cell format to Text and for the sorting check this article:
http://support.microsoft.com/kb/322067
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks