Pad field length
I have a spreadsheet with item numbers that range from 6-8 characters in
length. What I want to try to accomplish is pad the end of those items
numbers that are less than 8 chars. with 0s so they are 8 chars. long. So
item # ME850C will pad out to ME850C00. Can I do this in Excel 2000?
Thanks
|