Or, if you really want them to have 11 digits and not be numbers any more
(maybe they are product codes or something), how about this.

Col A Col B
5231 =REPT("0",9-LEN(A2))&A2&"00"
306 =REPT("0",9-LEN(A3))&A3&"00"
345 etc
70 etc

Then you could copy Column B and do EditPaste SpecialValues to fix those
values in the cells.
--
Allllen


"Janna" wrote:

In Excel I have a column that contains a number of values, for example:
5231
306
345
70

I want to remformat the column as follows:
00000523100
00000030600
00000034500
00000007000

(add two zeros to end and pad the front with enough zeros so the column
contains 11 characters total)

Anyone know of a macro or formatting technique to do so easily? Thanks.