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

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

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

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

Hope this helps.