If you don't want to use Paste Special, you could include the =VALUE
function within the formula to convert the data to numbers, eg

=VALUE(RIGHT(A1,4))

HTH

Phil

tim :/ wrote:
...last 4 digits from a column of text and copy them into a new column?

I have a report with about 3000 cells in a column. In each cell is an
address and the last 4 digits is the post code. I want to run a formula that
will automatically take these last four digits and cut or copy them into a
adjacent column...

Many thanks all,

Tim.