I am new to Excel VBA macros.

Is there a way to change an entire column where the cell contents are changed to have only the last 5 characters of its existing value?

Example
Column A Before
123456789
234567890
345678901

Column A After
56789
67890
78901

I have tried the Macro =RIGHT(A:A,5) and received a circular reference error