View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lindy Lindy is offline
external usenet poster
 
Posts: 16
Default concatenate problem

Help Urgent

I have a column with variable length numbers. I need to put these in a new
column with leading zeros in front to make the length of the new cell to 10.
Example for cell with 23, I need a new column to hold 0000000023.
--
Lindy