We seem to have cross-posting here. I suggested in the other thread
that you should ensure H2 is not formatted as text - click H2, Format |
Cells | Number (tab) then select General. Then double click the cell as
if to edit and press <enter - you should see the final 7 digits. Then
copy down and sort.

Hope this helps.

Pete