Thank you for your help. That is exactly what I needed.
"Peo Sjoblom" wrote:
You can use a help column, assume the example is in A1
=A1&REPT("0",8-LEN(A1))
copy down and paste special as values then paste over the old entries if
needed
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
"MarkM" wrote in message
...
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 0's so they are 8 chars. long.
So
item # ME850C will pad out to ME850C00. Can I do this in Excel 2000?
Thanks