numbesr in single cell to digit multiple cells but aligned ones,tens...

[wfsai]

Hi Friends,

Need help. What functions or formulas or solution to solve numbers in a one cell to put each digits to multiple cell but aligned cells on ones, tens, thousands and millions:

example: A1 450.25 will look like this 4 5 0 . 2 5
A2 1450.25 will look like this 1 4 5 0 . 2 5
A3 21450.25 will look like this 2 1 4 5 0 . 2 5

In short spreading single cell numbers in multiple columns in digits but the spread will be from the ones to tens and thousands or aligned from the last.
I need a quickfix for the link on computed numbers to the forms which is on the separate sheets with different boxes or columns.

Please help ASAP.

THANK YOU

[DBY]

Hello
The MID function copied across as many columns and down rows as you need.

=MID($A1,COLUMN(A1),1)

Hope this helps.