Thread: how do i eliminate leading 0 in a text 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 0 in a text 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 want to easily eliminate them.
Reply With QuoteReply With Quote