| Thread | Last Post | Replies |
|
| DDE server advstart on StdDocumentName | 20 Aug 2007 16:32 GMT | 1 |
Any idea why excel always send item request for StdDocumentName . Can this be prevented or is there a way to know if StdDocumentName req was actually sent by user by typing a excel macro. Thanks.
|
| Setting Cell Formats | 20 Aug 2007 16:10 GMT | 3 |
I am putting a time format to a cell in excel. When I have users type in the time like start and end times, the start time is always AM and the end time is always PM however I cannot get the end time to default to PM. Is there a way to default the cell to PM all the time with ...
|
| conditional formatting error | 20 Aug 2007 14:11 GMT | 3 |
I am attempting to conditionally format cells as follows: Cell value is between 1 and 30 = green Cell value is between 31 and 60 = yellow Cekk value is greater than 60 = red
|
| Adding to exsisting MACRO | 20 Aug 2007 12:41 GMT | 2 |
Rick: Thanks for the info however, I am not a programmer and would appreciate a little help. The following is a macro I created. I would like to include the "proper" code into the this.
|
| How to Increment Time using EXCEL ?? | 20 Aug 2007 07:46 GMT | 3 |
I'm using, and love it, Excel 97. I want to know how to increment TIME. Say I have a few rows, each start at 10:00 AM and I want each to increment at different intervals. Let's say row 1 is 15 min, row 2 is
|
| format error | 19 Aug 2007 22:02 GMT | 1 |
I have a row for dates. I have formatted them to be dd-mmm-yy. I enter the date and when I hit enter, it comes up as ######. PLZ HELP!!!!
|
| Calculating amount after subtracting percent | 19 Aug 2007 20:47 GMT | 1 |
Heres what i would like to do. I would like column b to equal column a minus x percent and appear in column c. The goal is to only have to eneter one formula and it will automatically fill it in to the corresponding row. EX.
|
| Macro Securiy Level | 19 Aug 2007 19:54 GMT | 4 |
I have a lot of Excel files with macro inside. Is it possible to set the level of Macro Security to "Low" once and for all (Excel 2002 SP3) ? Thanks in advance. Regards,
|
| Extract data from a cell after a constant value | 19 Aug 2007 19:44 GMT | 2 |
Howdy All, I have a spreadsheet that contains 1 column of data, if the cells of the column are the city names and populations of towns in the following format: Appleton, Wisconsin (WI) (pop. 70,087)
|
| Help- Changing Case | 19 Aug 2007 18:00 GMT | 3 |
Good morning: Excel 2003: I need to change the case on imported data from "CAPS" to "Proper". I thought it would have been an easy process but I was wrong. Any help would be greatly appreciated
|
| cells within cell | 19 Aug 2007 15:40 GMT | 1 |
In an existing worksheet I have cells hemmed in, not able to add additional rows or columns. I need 4 more cells in the column but do not have room to add them. Is there a way to click on a single cell that pops-up a mini-column of 4
|
| Creating Football League Tables | 19 Aug 2007 12:47 GMT | 1 |
I work for a premier football club, and wish to put results in to a format so that position and points can be updated at home showing league position week by week Cheers
|
| Counting number of characters? | 19 Aug 2007 12:46 GMT | 1 |
basic question but I am a really new user of Excel. I hope that somebody will help me. I need to count all characters (including spaces) in all marked cells. is there any simple way to do this?
|
| Extracting some text from a string. | 19 Aug 2007 12:37 GMT | 15 |
I'm trying to extract some specific text from a bunch of strings of text. I think this should be really easy but I can't get it done. I've used "Left" "Mid", "Substitute" and "Find" in one combination of another and sometimes it works but it doesn't always work.
|
| FileSearch gone in XL2007? | 19 Aug 2007 10:27 GMT | 1 |
I don't have it but just heard this. Really? If so, then to build a list of files in multiple directories, would we be required to devise a recursive blend of chdir and dir? Or DIR c:\{somespec} /S > foo and import foo?!
|