| Thread | Last Post | Replies |
|
| Save as CSV File | 24 Mar 2008 02:54 GMT | 1 |
I noticed some strings about getting rid of quotes. I want to get them. I would like to save my list as as CSV file, BUT I want quotes and commas. I only get commas. I went to help and was told I can do it in Visual Basics; however, I do not know how to use the Visual Basic ...
|
| Formula to compare numbers in 3 columns | 24 Mar 2008 02:50 GMT | 1 |
I have three columns each with different numbers. Column A has only two numbers, Column B has 7, and Column C has 5. I need to know when the numbers in Column A and the first two numbers in both Columns B and C do not equal. I created the formula =IF(OR(A1<>LEFT(B1,2),LEFT(C1 ...
|
| Help with ranking | 24 Mar 2008 02:17 GMT | 6 |
Using "RANK" should automatically rank eg. 10 observations from 1 to 10 and if 2 observations have the same value they should rank eg. 7 and 7 and the next rank would then be 9. I have made several collums and for som collums this is actually so. However
|
| invoicing with excel | 24 Mar 2008 01:52 GMT | 3 |
Is there a template which can be used for invoicing?
|
| Creating styles | 24 Mar 2008 01:33 GMT | 3 |
How do you create a new style and assign a toolbar button to it
|
| How do I convert A-E grades to number averages? | 24 Mar 2008 00:38 GMT | 18 |
I enter grades into Excel in an A-E format. I would like to create a number average, where A+=1, A=2, A-=3 etc, so that it picks up an A, B+ and C- average out to a numerical value of 5, which I could therefore give a B overall to. Have wasted valuable hours on this.
|
| Hlp! Reverse select in range | 23 Mar 2008 23:42 GMT | 4 |
Was wondering if there is a shortcut key or hidden toolbar button that reverses what I have selected in a data range. For example, if I have a range from A1:M30 and select from C10:E20 and then wish to just click a button to deselect C10:E20 and select the other cells in the ...
|
| create calendar with only M-F and add multiple repeating events | 23 Mar 2008 21:54 GMT | 1 |
Excell 2002. I want to create an office task calendar. The tasks would be recurring events. The recurrent rate would be based upon the number of people who can do the task. There would be three different tasks, each with its own rate of
|
| Automatically enter a percent for each month of the year. | 23 Mar 2008 21:24 GMT | 4 |
In A1 thru L1 i have months: A1=Jan, B1=Feb, C1=Mar etc In A2 thru L2 will be total for each month. In A19 i have a percentage ex "34%" that varies up and down every day.. In A20 i have "today()" date ex 3-23-08
|
| Cut-and-paste problem | 23 Mar 2008 21:02 GMT | 1 |
When I cut two adjacent columns from a worksheet and paste them into Notepad, I lose the indentation in the second column, which is formatted as Text. Also, the first column, which is formatted as General and contains numeric formulas, becomes left-adjusted instead
|
| Slide bars | 23 Mar 2008 20:55 GMT | 5 |
When I opened my worksheet the bottom and right side slide bars had disappeared. The only way I can move through my worksheet is going cell by cell. How do I find the slide bars?
|
| .wdb in excel | 23 Mar 2008 20:45 GMT | 3 |
My old computer had MS Word and Works. My new computer has MS Office and Excel. Some of my files are saved as .wdb Is there any way I can get them back and work on them in Excel?
|
| Display of a hyperlink .jpg file in Excel 2002 | 23 Mar 2008 20:37 GMT | 5 |
Something happened to my machine when I was at a website and a number of things got screwed up. I fixed several, but something happened to Excel. I am running XP on a Dell PC. I have numerous excel spreadsheets with hyperlinks to .jpg pictures. After
|
| % formula | 23 Mar 2008 20:15 GMT | 2 |
I have a cell that contains the % of an hour this has to be mutiplyed by the number of people attending say a safety talk in another cell at present I sit and scratch my head for hours if not days trying to work the thing out. Is there a formula that I can use if any one can help ...
|
| Save As Error | 23 Mar 2008 18:50 GMT | 2 |
objWkb.SaveAs saveFolder & "\DAILY WAR ROOM LOG_" & Format(DATE, "mmmm dd", "yyyy") & ".xls" I am getting a "Type Mismatch error", any ideas why?
|