Copying the formula horizontaly keeping the same column but changing row number

Hi
My title probably doesn't explain my problem in full.
I have a formula from other member of this forum but id doesn't work when I trying to copy it accross all columns....
I would like column reference to be A for every column I copy formula to but not the row number, I have tried absolute and relative referencing but it does not work as it should.
Here's the formula to extract last few numbers from text.

Formula:

Please Login or Register  to view this content.

Thanks
D

Originally Posted by bebo021999

Try in B3:

Please Login or Register  to view this content.

Hi Bebo
Works like a charm.
Thank you.
Dan