Converting multi-digets in one cell into each diget in it's own cell

Coney,
Try this:
Your 10-digit number in cell A1
In cell A2, type in the following formula, then drag-and-fill through cell J1 (column 11):
" =(MID($A$1,COLUMN(A1),1))" (without the quotes)

HTH, FrankB

you could also highlight the column, selecting :

Data
Text to columns
fixed width

and click to insert column seperators as needed after each character

Frank's method is probably quicker and I've often found copy/paste problems after using text-to-columns (ie reboot)

Another option though !
HTH
Chris D