View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default how do i covert 9780764311223 to read 987-0-7643-1122-3

if they are really numbers format-cell-numbers-custom
000-0-0000-0000-0
if they are text that looks like numbers
=left(A1,3)&"-"&mid(a1,4,1)&"-"&mid(A1,5,4)&"-"&mid(A1,9,4)&"-"&mid(a1,13,1)

"ian78" wrote:

I have a column 0f 3500 of numbers to convert