number formatting

Z

zuraan

Hi. I was woundering how I can add trailing zero's to numbers. I have
a colunm with number lemgths between 1 and 7 digets and need them all
to be 10 diget's long. I have no trouble with adding the zero's as
headers but needt hem as trailers. Thanks.
Click to expand...


Thanks all for the replys. I was hoping I could do it through the -
"Format Cell, number, custom" tools built into Excel but can only put
leading zeros and not trailing ones. Thanks again
 
Top