| Thread | Last Post | Replies |
|
| Resize Data Labels | 20 Sep 2006 10:18 GMT | 1 |
How do I resize data labels within a graph? I know how to resize the font, but I need to know how to put the contents of the label on one line opposed to two. I cant seem to figure out how to resize the actual label.
|
| Macro Error | 20 Sep 2006 09:56 GMT | 1 |
Have done this to call two macros and its gets an error Sub Master() 'calls two other macros MoveNumbersForRPA
|
| Formatting cells to display numbers in euro style | 20 Sep 2006 09:40 GMT | 1 |
How can I format specific cells in Excel 2003 spreadsheets to display numbers in French euro style (43,00 € rather than 43.00 €). I have added the currency conversion toolbar, but that still displays using a decimal point. Since most of my calculations are in dollars, I don't ...
|
| Data Table | 20 Sep 2006 08:29 GMT | 4 |
I have created a table with in an excel spreadsheet with the following data and I would like to create a data table to infill the cells for me but I can't seem to get it too work, please help. The spreadsheet has been completed as follows:
|
| Lookup Function | 20 Sep 2006 06:41 GMT | 8 |
I have a simple table with 4 rows and 3 columns on one worksheet - A4:C7. On another worksheet I would like to lookup a value from the table and have it show up in cell F2. The column and row headings are NOT numbers. They are text, so I don't think HLOOKUP or VLOOKUP will ...
|
| employee schedule | 20 Sep 2006 05:44 GMT | 3 |
I need to make a schedule. The schedule will be for a full month. I want to enter the employee name, the date, the shift they are going to work (8:45am-7:30pm). I want the spreadsheet to automatically show the hours for that shift, and then show a total at the end for all ...
|
| vlookup- is a must that lookup value should be the leftmost colum? | 20 Sep 2006 04:30 GMT | 3 |
Since the table which i want to search are often not ranged as the lookup value located in the leftmost column, should I always need to adjust the column sequence of the table so as to use "Vlookup" function. It's really a bother.
|
| Inconsistent excel 2007b2 time calculations that span whole days | 20 Sep 2006 03:51 GMT | 2 |
I want to have the total number of HH:mm between two times on different days (as part of a comparison). I have a screenshot showing inconsistent behaviour, where diff between 29-09-06 15:01 and 30-09-06 07:25 is rendered (as expected) as 16:24, then
|
| Automatically updating a workbook from a different workbook day by | 20 Sep 2006 03:35 GMT | 4 |
I am using Excel 2003 and I am wondering if there is a way to automatically update an Excel workbook from another workbook. I have example files, and some comments within that explain this better, however I can not figure out how to insert the example files into this posting. ...
|
| Conditions | 20 Sep 2006 03:15 GMT | 2 |
I am trying to make conditions for each cell i.e. =$A$1<0 Take that and drag it down so I don't have to enter =$A$2<0
|
| NEWSREADER | 20 Sep 2006 03:01 GMT | 2 |
Where in microsoft.public.excel._______________? (in my Outlook Express newsreader) will I find the newsgroups pertaining to CHARTS, i.e. Excel Charts? Thank you,
|
| Printing schedule with auto increment workday date | 20 Sep 2006 02:53 GMT | 5 |
I'm trying to set up what I think should be a macro that runs on a print event. I have an office schedule that I print out for others to fill in. I'd like the date in merged cells c1:j1 to have the date (dddd, mmmm d, yyyy) be in
|
| Create an Excel Update for COUNTIF Formula | 20 Sep 2006 02:42 GMT | 1 |
Many people have posted topics regarding using the COUTNIF funtion in multiple worksheets. Maybe the good guys at Microsoft can release an update for Excel to utilize the COUNTIF function in multiple worksheets. ----------------
|
| Can Excel describe a function in two variables: y = f(x,z) | 20 Sep 2006 01:23 GMT | 3 |
I have two independent variables (inputs: x, z) and one output: y. I have the data for all three variables in columns in an Excel 2000 worksheet. Can Excel graph and fit an equation to this data? I want an equation of the form y = f(x,z). Thanks!
|
| Is there a way to concatenate date and time? | 20 Sep 2006 01:14 GMT | 5 |
If there is a date in one column and a time in another is there a way to make the third column DateTime based on a conatenation of the other two columns?
|