Enter this in A2 (or anywhere), and copy down:

=RIGHT(LEFT($A$1,ROWS($1:1)))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"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