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