Thread: how to keep all leading zeros when stripping dashes from txt num
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Tevuna Tevuna is offline
external usenet poster
  
Posts: 136
Default how to keep all leading zeros when stripping dashes from txt num
Sue's is good.
Or you could format cells as Text (@) PRIOR to replacing hyphens.
Reply With QuoteReply With Quote