View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anthony
 
Posts: n/a
Default inserting a space in a number

hi

have 15 digit numbers downloaded off scanner but need to insert a space
between 3rd and 4th digits.

3000 to do so how can i do it with function or formula

ie. 982123456789876 should be 982 123456789876

thanks