Thread: Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Basta1980 Basta1980 is offline
external usenet poster
 
Posts: 102
Default Format

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