Thread: Leading Zeros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ben Watts Ben Watts is offline
external usenet poster
 
Posts: 1
Default Leading Zeros

I have a column that has leading zeros. I want to get rid of all leading
zeros. Some have 3, some have 2...etc....SOme of the cells have letters in
them also. SO what can I do? Thanks