Separate numbers in different columns by a formula

Closed
azam - Sep 26, 2014 at 07:26 AM
Hello,

I want to separate numbers in different columns by formula.
For example: in Cell (A1) having number 106,504.00 separate in different cells by transfer 100,000, 6,000, 500 and 4 in four different cells. (number in Cell A1 separate in 4 different columns.