On Mon, 4 Jun 2007 04:38:00 -0700, 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).

If you want to divide the 5527 into the values you mention, you would have,
instead of 7 (ones), 1(five) and 2 (ones).

In any event, for integers as you indicate, you can do the following.

Set up your top row as follows:

B1: $1,000
C1: $100
D1: $10
E1: $5
F1: $1

A2: $5,527

B2: =INT($A2/B$1)
C2: =INT(($A2-SUMPRODUCT($B$1:B$1,$B2:B2))/C$1)

Fill right C2:F2

Then fill down B2:F2 as far as you require.

If "cents" will be used, then add the value of the coins you want to use to
G1:x1

e.g. G1: $0.50
H1: $0.25

etc.

and change the formula in C2:

=INT(ROUND(($A2-SUMPRODUCT($B$1:B$1,$B2:B2))/C$1,2))

to take care of occasional issues with Excel's handling of decimal numbers.

Fill right and down as before.
--ron