Thread: how do i eliminate leading 0 in a text cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default how do i eliminate leading 0 in a text cell
Select the range
edit|replace
what: 0
with: 0
replace all


REST wrote:

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.

--

Dave Peterson
Reply With QuoteReply With Quote