How to divide a number into various denominators
There's probably an easier way but try this with your number in A1:-
=INT(A1/1000)&" (Thousands) "&INT(RIGHT(A1,3)/100)& " (Hundreds)
"&INT(RIGHT(A1,2)/10)& " (Tens) "&INT(RIGHT(A1,1))& " (Ones)"
I haven't allow for decimals portions.
Mike
"maa" wrote:
How to divide a number into various denominators eg thousands, hundreds,
tens, fives & ones for example 5527 can be divided into 5 (thousand), 5
(hundreds), 2(tens) & 7 (ones).
|