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