| Thread | Last Post | Replies |
|
| trying to select multiple cells | 11 Sep 2006 17:09 GMT | 7 |
Hello. I can't remember how to select multiple cells in this worksheet. example I want to select a1 to i11 or something. I need to use the keyboard for this as I am visually impaired and cannot use a mouse. Thanks.
|
| Formatting when combining text & value in a cell | 11 Sep 2006 17:03 GMT | 2 |
The value of my cell is ="Product Margin is "&Z5 Z5 is 63.6% (in Z5) but 0.63653676693 in my combined cell. How do I format the percent when combining text & value? Thank you for your
|
| Creating a Database in Excel | 11 Sep 2006 14:11 GMT | 9 |
I may not be able to do this, but I figured someone on here could tell me. I am a music minister and I am trying to create a list of all the songs we use in the services. It will have the title of the song, the temp, key and last time used and I would like to have a running ...
|
| Rounding problem | 11 Sep 2006 13:54 GMT | 1 |
I have a series of 16 and 18 digit numbers that I am trying to store and work with. If for example I have the number 1234123412341234 and I leave the field unformatted I get '1.23412E+15' which is fine. If I change the cell
|
| First Positive | 11 Sep 2006 13:28 GMT | 4 |
I am trying to obtain the value of the first positive in a column to place in a summary location. The column starts with negative values. I would appreciate help with this question
|
| Rounding problem | 11 Sep 2006 13:16 GMT | 2 |
I have a series of 16 and 18 digit numbers that I am trying to store and work with. If for example I have the number 1234123412341234 and I leave the field unformatted I get '1.23412E+15' which is fine. If I change the cell
|
| Application-defined or object-defined error | 11 Sep 2006 11:12 GMT | 1 |
I find myself stumped by an incredibly easy piece of code and one that I have used before. I am getting the error: Run-time error '1004':
|
| Help with referencing please | 11 Sep 2006 10:15 GMT | 18 |
I'll try and explain exactly how my spreadsheet is laid out and what i'm trying to achieve. The sheet is designed to log newspapers and wakeup calls that are ordered by guests in a hotel. I have the newspaper side of things working as intended,
|
| macro disabled permanently | 11 Sep 2006 09:44 GMT | 1 |
I interrupted a macro I wrote that went into infinite loop by hitting ESC. I fixed the macro function which is tied to "Worksheet_Change". Now it never gets triggered. I put break points in code; not executed at all. I close/open excel and respond to security dialog as "enable
|
| Exracting numerical data. | 11 Sep 2006 09:20 GMT | 10 |
Sorry, I recently mistakenly posted this to excel.charting. I recently had to extract the numerical data from text in the cells of a fairly long column. Since my problem was something I don't expect to have to do frequently, I simply
|
| Newbie help question (date and time) | 11 Sep 2006 09:00 GMT | 2 |
I want to add a couple of commands to a custom toolbar that I have made. I want to add a button to insert the current date in the active cell and another to insert the current time in the active cell. My problem is I can't find ANY commands on any toolbar that does those
|
| display order of worksheets | 11 Sep 2006 08:36 GMT | 4 |
I would like to have multiple worksheets in the same book displayed in a predetermined order whichever worksheet I work on. How can I do this?
|
| autofilter help | 11 Sep 2006 07:54 GMT | 3 |
when i set my auto filter it stops at blank lines rather than allowing me to select "blanks or non blanks" the data that it filters doesnt pass the blank line so i have dispatched
|
| Would like to display 1-30 in cell | 11 Sep 2006 06:35 GMT | 3 |
Typing in the term 1-30 in a cell always returns the date Jan-30. I understand date formatting but I would like to display the term 1-30. The next cell is 31-60 and displays properly. How do I do this. Thankyou.
|
| Don't merge cells? | 11 Sep 2006 03:10 GMT | 9 |
Thanks for your response, Roger. I am aware of this feature but I can't get it to produce the same effect as merging cells will. Am I missing something? Let's say I have Jan Feb Mar ........ starting from A2 and going across. Above the months and in row 1, I want to include a ...
|