Hi Chris,
If you don't want to use a macro you could select an
empty cell and copy it (Ctrl+C) then select the cells
to be reentered, edit, paste special, add

Note this could change formatted values such as dates
to numbers but formulas would remain intact, except for
the addition.

A better way is to select the cells or columns you want to
reenter and run the TrimALL macro
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
There are important notes along with macro, if you are
interested in finding out what you actually had in your cells.
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Chrism" wrote in message ups.com...
Does anyone know why? Or how to make that happen w/o retyping all 200
numbers (employee numbers) multiple times on the list? I know that
when I retype the numbers then the formulas can 'see' the number and do
the calcualtion, but not if I don't retype. The formats are the
same(number).

A C Z AA
1 EmpNo Units Empno Ttl Units
2 77 7 77 10 =SUMPRODUCT(Empno=Z2)*(units))
3 77 1 9533 11
4 77 2 10058 14
5 9533 7
6 9533 1
7 9533 3
8 10058 6
9 10058 2
10 10058 3
11 10058 3

Any and all help would be greatly appreciated

Thanks
Chrism