On Sun, 23 Oct 2005 20:08:09 +0100, "Nick Hodge"
wrote:

Richard

I've had no response from the poster yet but I suspected he wanted to know
how many 100's, how many 50's, how many 20's, etc were in the number in A1,
so in the example given (6566) (I think he has confused his examples), you
end up with 65x100s, 1x50s, 0x20's, 1x10s, 1x5s, 0x2s and 1x1s. (I think he
just left gaps instead of zeroes)

I suspect we'll know when time zones allow ;-)

You're probably right Nick. One of my guesses was that he was making
up wage packets and wanting to know how many notes/coins of each
denomination was needed.

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________