that helped so much i could kiss u i have been fighting with this for over 2
hours now !! my only problem is that when i try to total all the net pays for
the 6 employees it is still coming up as those number signs even when i
change the format ... but the rest are fixed THANK U SO SO MUCH!!!

"Ms-Exl-Learner" wrote:

Place the cursor on that particular cell and Do right clickFormat
CellsNumberCategorySelect Number and give Ok.

Remember to Click Yes, if this post helps!
--------------------
(Ms-Exl-Learner)
--------------------


"bruces girl" wrote:

i am writing a paper for school and i have to calculate the net pay on a
spreadsheet. the formula my professor wants me to use is gross pay -(
federal tax+state tax)
i used formuia =e3-(f3+g3) and it produces a series of #### in the net pay
category however if i hover over them it pops up with the correct total ..
how do i make it show the total in the box not just a series of number signs?