I'm glad you liked it. Keep in mind that this formula will only work if
placed in row 2. To be able to place the formula anywhere, then you would
need to modify it slightly. In fact, this will probably be the better
recommendation.

=MID($A$1,ROW(A2)-1,1)

Regards,
Paul

--

"Forum Freak" wrote in message
...
WOW brilliant - that was much neater than a formula I saw a while ago.

Many thanks

Kenny

"PCLIVE" wrote in message
...
You could put this formula in A2 and copy down.

=MID($A$1,ROW()-1,1)

HTH,
Paul

--

"Forum Freak" wrote in message
...
Hi everyone

I am sure I have seen this before but it is not showing up on Google.

A1 has a 5 digit number eg 12345
I want a formula or VBA code to produce
A2=1
A3=2
A4=3
A5=4
A6=5

anyone point me in the right direction?

Kenny
Win XP
Office 2003