Format

  • Thread starter Thread starter Basta1980
  • Start date Start date
B

Basta1980

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.
 
Back
Top