Select and adjust a value based on a total
 

Windows XP Pro SP2
Excel 2003 SP2

I have 7 rows (Column B) with numbers in them that are derived from another
set of 7 numbers (Column A).

I need the 7 rows in Column B to add up to 100.00 with no variance to that
total.

Is there a formula (not VBA) that will look for the first number in the
group of 7 that carries a tenths-place number (10.1 vs. 10) and add a tenth
to it, then continue to the next value with a tenths-place number and add a
tenth to it, etc. until the 7 numbers add up to 100?