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.
 
O

OssieMac

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
 
R

Rick Rothstein \(MVP - VB\)

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top