copy last five digits in one column

[George]

I need to copy the last five digits in one column to
another column.

G

 

[Ken Wright]

As posted elswhere:-

With your data in A1

=RIGHT(A1,5)

If you need them to be numeric, then:-

=--RIGHT(A1,5)