Thread: how to keep all leading zeros when stripping dashes from txt num
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sue Sue is offline
external usenet poster
  
Posts: 285
Default how to keep all leading zeros when stripping dashes from txt num
I have a text column that contains formatted numbers.
I need to strip the dashes, but preserve ALL numbers.
When I use replace to strip the dashes, Excel automatically changes the
cells to numbers format and I lose all the leading zeros.
Reply With QuoteReply With Quote