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

[ciapul12]

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.

Please Login or Register  to view this content.

Thanks
D

[bebo021999]

Try in B3:

Please Login or Register  to view this content.

[ciapul12]

Try in B3:

Please Login or Register  to view this content.

Hi Bebo
Works like a charm.
Thank you.
Dan