Thread: REMOVE LEADING ZEROS
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ichihina ichihina is offline
external usenet poster
  
Posts: 3
Default REMOVE LEADING ZEROS
00456 Tickford Dr.----456 Tickford Dr.
0785 Fort St.----------785 Fort St.
000309 Old Rock Dr.--309 Old Rock Dr.

How do I remove the leading zeros for these addresses?
Reply With QuoteReply With Quote