Functions

Row Height or Column Width not Showing
When I left click on the row it use to give me the row height and now for some reason I can't see that anymore. I have to right click and select the row height to see the size. I already put the CD in and ran the repair on it and that didn't work. Any ideas onwhat to try? ... 19 Mar 2010 16:41

Recurring header.
I did an Excel worksheet and placed a header on it. When it printed, it automatically did column headers (A,B,C,D). The header and column headers now print on every document that I print, including Word documents and e-mails. How can I get rid of the header? ... 19 Mar 2010 15:32

combining dates and text in a cell
Hello-- I had a column with dates and another with text labels. I'd like to combine these and tried using this formula: =D6&" "&I6 D6 = 7/4/2009 I6 = HOLIDAY Is there any way to do this to get the actual date and not the numberical value returned? Thanks in advance for your help. ... 19 Mar 2010 15:32

No Balance Owed Flag Help!
Trying to resolve this formula to work appropritely in cell E7: =SUM(E2:E6),IF(E2:E6=0,"No Balance Owed") In other words, all currency outcomes are totaled in cell E7, however, if all outcomes in cells E2:E6 are $0.00, than I'd like cell E7 to say "No Balance Owed". Any help would be appreciated! Thanks ... 19 Mar 2010 16:41

formula required
Dera plz solve my problem, i m working in a bank my query is that Today is 9-mar-10 my ending balance is 10,0000.00 in sheet 1 column A2 . and this balance automatically will insert sheet2 under (ENDING BALANCE) I want that next day on 10-MAR-10 my ending balance will that i will put in Sheet 1 coulmn (A2 )same... 19 Mar 2010 13:14

what does the size 1/72 means
trying to find out if appies font or point ... 19 Mar 2010 16:41

Two digit number with one decimal, or three digit number
I would like to have one decimal point in a number, unless the number is 100 in order to fit the columns in a table. So, three digits for whatever number I type in, and if it is two digits, to have a decimal. 95.6 45.2 80.0 100 - NOT 100.0 123 - NOT 123.0 Thanks! ... 19 Mar 2010 10:48

how do i create a formula to give a workday date?
I am trying to set up a worksheet the gives me a date during the work week that is 5 work days, 10 workdays, etc from the date that is entered. I also want the cells to result in TBD until the first date is input. Here is an example of the formula I created that gives me TBD but not a workday date. =IF(H28... 19 Mar 2010 13:14

a Counting question
hi to all I'm sure this is easy, but I'm new to Excel. I need a function that will COUNT all the numbers in a range (B5:B1525) equal to or greater than the value in A3. (all values are positive integers) thanks in advance -- cinnie ... 19 Mar 2010 14:23

How to check if the values in a range of cells are greater than 0
Basically I want to check like IF(B3:B5 > 0,B1), if any of the values in B3 to B5 cells are greater than 0 then I take the value from the cell B1. How to do it in a simple way. If I use directly the above mentioned formula, it gives me a #VALUE error Thanks ... 19 Mar 2010 10:48