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