|
excel question
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? |
excel question
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? |
excel question
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? |
excel question
Have you tried selecting all the cells (cells in which you are getting #####)
and formatting those cells with Number format? Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "bruces girl" wrote: 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? |
excel question
yes i tried ... it worked for all of them but the total ... i can't put it in
anything but number format ...its required to bein currency but oh well at least its showing actual numerals now thank you so much for all your help ... i have never used excel before this class and hope after this week to never ever see it again lol "Ms-Exl-Learner" wrote: Have you tried selecting all the cells (cells in which you are getting #####) and formatting those cells with Number format? Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "bruces girl" wrote: 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? |
excel question
You're Welcome and thanks for feeding back!
Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "bruces girl" wrote: yes i tried ... it worked for all of them but the total ... i can't put it in anything but number format ...its required to bein currency but oh well at least its showing actual numerals now thank you so much for all your help ... i have never used excel before this class and hope after this week to never ever see it again lol "Ms-Exl-Learner" wrote: Have you tried selecting all the cells (cells in which you are getting #####) and formatting those cells with Number format? Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "bruces girl" wrote: 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? |
excel question
|
excel question
Make the column wider - typically ##### means that there is a number in the
cell, but the column/cell isn't wide enough to display it. "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? |
| All times are GMT +1. The time now is 01:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com