Hi,

Am Tue, 18 Jun 2013 17:53:46 +0100 schrieb applemanxxx:

I have to manually input the formula in to each cell, here what
happens:
=MID(A3,ROW(11:11),4) – 1 CELL The original formula returns 4
digit number
=MID(A4,ROW(12:12),4) – 2 CELL The original formula returns 3
digit number
=MID(A5,ROW(13:13),4) – 3 CELL The original formula returns 2
digit number
=MID(A6,ROW(14:14),4) – 4 CELL The original formula returns 1
digit number
ETC….. I think you get the picture …ROW(N, N) keeps changing
as I try to copy it down, thus, as I stated it earlier, I must do
manually…. Any thoughts??

try:
=RIGHT(A3;4) and copy down.
You can copy the helper column and pastespecial paste values and apply
custom numberformat 0000.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2