number formatting

  • Thread starter Thread starter zuraan
  • Start date Start date
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.
 
Hi zuraan,

You could put the following formula in a column beside the numbers and then
Copy, Paste special, Values over the original numbers.

=A1*10^(7-LEN(A1))

The formula assumes that the number is in cell A1
 
And another possible approach...

=--LEFT(A1&"0000000000",10)

or, if it will be copied through blank Column A cells...

=IF(A2="","",--LEFT(A2&"0000000000",10))

Rick
 
Back
Top