Thread: how do i covert 9780764311223 to read 987-0-7643-1122-3
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default how do i covert 9780764311223 to read 987-0-7643-1122-3
Custom format 000-0-0000-0000-0, or formula =TEXT(A1,"000-0-0000-0000-0")
--
David Biddulph

"ian78" wrote in message
...
I have a column 0f 3500 of numbers to convert


Reply With QuoteReply With Quote