View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MarkM
 
Posts: n/a
Default 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