Thread: If I have a list of numbers, how do I insert a dash in each one?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default If I have a list of numbers, how do I insert a dash in each one?
Format Cells... Number Custom 00-0000-000-00
--
Gary''s Student - gsnu200908


"rayofsunshine969" wrote:

If I have a list of numbers, 11 characters long, example: 00229603210, and
for each number I want a dash behind every 2nd, 6th and 9th number,
00-2296-032-10. Is there an easy way to do this?
Reply With QuoteReply With Quote