Thread: how do I eliminate leading "0s" in an alpha numeric cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
REST REST is offline
external usenet poster
  
Posts: 8
Default how do I eliminate leading "0s" in an alpha numeric cell
I have ID numbers that are alpha numeric. Some are all numeric formatted as
text, others are actual alpha numeric combinations. Most all have leading
"0s". I was hoping I would be able to use a function in a formula to easily
eliminate them.
Reply With QuoteReply With Quote