| Thread | Last Post | Replies |
|
| Change Toolbar Location | 20 Apr 2006 17:28 GMT | 1 |
Hey All... Dug around for a while around the groups to find a solution but could not find a clear cut answer. I loaded a customized toolbar into excel. Everytime I start excel the
|
| Try again: Using mail-to hyperlink with an attachment | 20 Apr 2006 16:53 GMT | 4 |
I'm creating forms using Excel and Word. Somewhere in the form is an email address. I can use Edit-hyperlink to specify the recipient address of the email address as well as the subject field. Great. What I'd really like is to be able to specify that the form file itself (the
|
| Have a question | 20 Apr 2006 16:51 GMT | 3 |
I hope this is not a repost... I have a Excel Workbook with four tabs. Now I want to get information from 1-3 (totals) tabs and place that information into some cells on tab 4. I don't want to cut and paste, I would like it to be a =sum or something like that. Can this be done?
|
| formulas | 20 Apr 2006 16:30 GMT | 2 |
how do I use a % range for instance if f13 is 25-75% in a formula
|
| Need Help Bad | 20 Apr 2006 14:50 GMT | 2 |
Hi I am new to this group and also excel so please excuse any mistakes :) I am trying to find a solution to a problem that I can not solve. I work in the restaurant industry and have a schedule that I made for my employees. The schedules work fine. What I am trying to achieve is ...
|
| Size | 20 Apr 2006 14:23 GMT | 4 |
I have an excel document that has grown to 40MB is size and is likely to grow a lot more in the next few months (potentially double). Does anyone have any information on acceptable file sizes for Excel documents, is there any official information from MS on this?
|
| Format doesn't stick | 20 Apr 2006 13:06 GMT | 3 |
I have a fairly complex but not overlarge Workbook. On one sheet Column Z is formatted with a custom format "d mmm yy". Columns AA is formatted as Number, 2 decimal places, with a comma for 000s In a macro I have
|
| Counting the Same Rows | 20 Apr 2006 12:33 GMT | 4 |
I have a spreadsheet with 2 columns column a is CustomerID and Column B is TransactionDate I need a way of counting how many transaction dates a customer as column A can have the same customer ID in multiple times
|
| Calculation date | 20 Apr 2006 10:03 GMT | 1 |
I want to find out how many days there between two given dates . A1 is for example 01.01.2006 and A2 is 01.02.2006 and in A3 I want the amount of days there are between A1 and A2. How can I do that?
|
| Calculation of days between 2 dates | 20 Apr 2006 09:37 GMT | 2 |
I have a problem: I want to calculate then amount of days between two given dates. A1: 01.02.2006 A2: 01.03.2006
|
| Data Compare | 20 Apr 2006 09:06 GMT | 1 |
Hi , Can you help :- I have 2 columns of numbers, what I want to do is separate the number that appear in both columns from the numbers that don't. the numbers that dont appear in both columns should be copied to column c
|
| Merging 2 columns into 1 and converting to other cases? | 20 Apr 2006 07:56 GMT | 4 |
A few questions: 1) how to convert a column [or row] of data into upper case? 2) how to merge two columns of names into 1 column where a space separates the two names
|
| Can you make paragraphs in a message box? | 20 Apr 2006 06:42 GMT | 5 |
I would like to have a message box with two paragraphs so that the message is easier to read. Is there a way to force words to the next line and/or skip lines in a message box? Thanks in advance.
|
| Displaying data that's longer than cells are wide | 20 Apr 2006 05:55 GMT | 6 |
Quick question: doing a project where I need to copy looooong items into small cells. Is there any way I can get Excel to only display the part that will fit in the cell? As it is, the data (text) spills out over adjoining cells, making it difficult to see which cells to the ...
|
| Sorting | 20 Apr 2006 02:32 GMT | 2 |
I need to sort a column in desending order so the first number is 121, 120, etc. down to 1. Some numbers have an alpha (68a, 68b) but I still want them in the correct order. Right now the cell formating is "general." How do I accomplish? Thanks!
|