Hi WM,

If your value 5891034 is in cell A1 use this formula:
=MID($A$1,ROW()-1,1)
Should the value be in an alternative cell modify the formula
accordingly, remembering that it requires an absolute cell reference
($s).

Cheers,
JF