L Lim Aug 5, 2009 #2 at correspondence column cell, build this formula =VALUE(SUBSTITUTE(A2,",","")) Copy down if more than 1, Then copy and paste special value to convert the formula back to value. Format cell as 1000 separator.
at correspondence column cell, build this formula =VALUE(SUBSTITUTE(A2,",","")) Copy down if more than 1, Then copy and paste special value to convert the formula back to value. Format cell as 1000 separator.
