Hi all,

I guess this is really just a small thing but I can't figure it out;

In Column A there's a list of numbers (9 characters long). In our company we
use a system which requires these numbers to be preceded by 2 zero's. I
reckon writing a code with copy and paste is the moste obvious but I want, if
possible, a smarter piece of code.

Any suggestions,

Thnx

Basta1980

You could change the format of the cells.

Format/Cells/Custom and then type "00000000000" (11 zeroes) in the "Type" box.


"Basta1980" wrote:

Hi all,

I guess this is really just a small thing but I can't figure it out;

In Column A there's a list of numbers (9 characters long). In our company we
use a system which requires these numbers to be preceded by 2 zero's. I
reckon writing a code with copy and paste is the moste obvious but I want, if
possible, a smarter piece of code.

Any suggestions,

Thnx

Basta1980