With your example, it's hard to tell a few things such as, are all the value in one cell of the row, are they all the same size in digits?

Can you past a sample workbook that would provide details with the above questions?