I have a label on my Excel chart Y Axis "Count" Arial 10 point bold. The lable is vertical. The "t" gets cutt off. I have tried changing the font etc, but no luck. How can I fix this, it's re...
Once I click on a cell in Excel it's as if I have a button pressed. I cannot do anything else within Excel. F8 does not fix this. Scroll lock is not on. The "EXT" and "SCRL" are not present. I...
I have a notepad that I want to convert into excel. The notepad is structured in this way,
Page 1
Field Description Pos ...
I am developing an excel timesheet for my organization. I have two units A and B
Unit A :
--------
Work Start Time : 9:30 AM
Work End Time : 7:00 PM
Tea Break Time 1 : 11:45 AM
...
I'm looking for a formula to calculate the number of the vacation days based on a seniority date and accrual rate. Below is the accrual rate. I would like to see the result in number of days...
Hi,
In excel, how can I use the Formula SUMIF(range, criteria, [sum_range]) to sum if NOT EQUAL to some text.
=SUMIF(A4:C4:, <> "Ops", A5:C5) does not seem to work.
Angus
I am looking for code that goes through a range and deletes entire rows when it comes to more than two adjacent cells that are empty. In other words, if there are 8 empty rows in a row in col...
I have 1 user on XP SP2 running Office 2007 that is having an issue opening excel files from network shares. I have checked all of his permissions and none have changed. This problem just st...
When i try and open an excel file from outlook 2007, using vista home, i get the following error message,"the system cannot find the file specified".
When i save it to my desktop or pc and ...
I don't have a good experience in Excel program so I want to put a date like dd-mm-yyyy in a cell like
1-Jan-2005 and in other cell 5-jan-2008 then I need to subtract two from one to get res...
I am using this formula to calculate a prorated rent amount:
=(DATEDIF(C20,C21,"m")*C8)+(C8/(EOMONTH(C20,0)-EOMONTH(C20,-1))*(EOMONTH(C20,0)-C20+1))-(C8/(EOMONTH(C21,0)-EOMONTH(C21,-1))*(EO...
For some reason, all excel documents on the computer will not open by clicking the saved document. However, if I open Excel first and select the OPEN document option and select the saved docu...
Hi,
I'm trying to work out the Compound Annual Growth Rate of company PROFITs.
The standard CAGR equation is:
=((end / start) ^ (1 / years) - 1)
That's fine where 'end' and 'start' are...
Experts
I have an Access app that queries SQL Server, and then dumps the results to Excel. I need to further process the Excel data before presenting the data to the user...
If you ha...
I have to submit this work today, would appreciate any help on this.
This is related to an earlier question I had posted, maybe Kevin or Patrick can help me out with this one. I want...
This is horrible if it's by design, so please let me know if there is a fix or if this is also what others are experiencing:
An Excel 2007 xlsx file is created. An Excel 2003 user, with th...
Hi,
I have an excel spreadsheet that I am attempting to import into Access.
The problem is it wont import due to Excel interperating a carriage return (new line) as a square.
If I use t...
Apparently you can use the evaluate function to get a result of a virtual cell, when you want to "evaluate" the value of a formula containing variables in VBA
For some reason the following ...
In Excel VBA I am pasting a large block of text into a group of cells in a column, selecting the column and selecting 'Wrap text" so it will all show. But the rows will only go to a height of...
Hi. I am having some trouble with a formula.
I am trying to apply some formats to a grid depending on what the value of the cell is.
I can use a for loop to jog through rows, but have no cl...
When I try to preview an Excel 2003 document, I get a message "Margins do not fit page". When I OK thru the message, it looks like each individual cell is going to print to a separate page. ...
I need to be able to export the contents of a custom list in an excel sheet because the Out of the box functionality of "Export to Spreadsheet" is not working because of form authentication. ...
I need a function that will take an entire cell value in Excel and convert the value into its MD5 hash equivalent in a new cell. I have seen several comments about using VBA or other software....
There is one user who accesses excel spreadsheets via a network share who often gets error message: "filename.xls is locked for editing by the username(its the user themselves) click to notify...
I have a button on a form that runs a query with a date on the form being used as criteria in the query. I also have an Excel Woorkbook containing a sheet that is linked to the query, and a p...
