View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rosygucci rosygucci is offline
external usenet poster
 
Posts: 4
Default I HAVE AN EXCEL FILE 3 COLUMNS , WHICH I HAVE TO ADD ON THE THIRD

I have to add a 0 in some of the numbers that are on the third column example
K10-01 should read K010-01 so that when i put them in order by number thay
will fall in the right order. is there an easy way to do this or do i have to
go change them one by one? remember these are cd's so i have to keep each
line together all columns must correspond. please help. thank you
rosy