Hi all
This is my problem:
I need a breakdown of a number that the user types in in cell A1, i
terms of 1000's and 500's and 100s and 10's and 1's
E.g 7551 would be
1000's = 7
500's = 1
100's = 0
10's = 5
1's = 1
and
786 would be
1000's = 0
500's = 1
100's = 2
10's = 8
1's = 6
and 11655 would be
1000's = 11
500's = 1
100's = 1
10's = 5
1's = 5
Any ideas? Many thanks al
--
HUBBUB8
-----------------------------------------------------------------------
HUBBUB88's Profile:
http://www.excelforum.com/member.php...fo&userid=2441
View this thread:
http://www.excelforum.com/showthread.php?threadid=38014