View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Spreadsheet Monkey Spreadsheet Monkey is offline
external usenet poster
 
Posts: 2
Default a macro for inserting

I need a solution/macro to insert a minussign (-) into a 10 digit number
between digit 6 and 7 (to get a number looking like this xxxxxx-xxxx)

I need to do it in a single column for all 65 536 lines of code in the
spreadsheet.

who of you is nerd enough to tackle this challenge?