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

Hi All,

Hope you can help me (think it's fairly easy). In column A there's list of
numbers (9 characters long). One of our systems requires that the list of
numbers (or per number) is preceded by 2 zero's, ie. 12345678 becomes
0012345678. I reckon a cut/copy and paste is a good option but (off course)
I'm looking for a piece of programming that changes the numbers into the
desired format.

Thnx in advance

Basta1980