| Thread | Last Post | Replies |
|
| How do i make my picture size display in inches rather than cms? | 02 Mar 2005 20:42 GMT | 1 |
I have inserted an image into exel. I need to resize it to match another image in another program that displays the size as inches. However the Excel image size menu shows the size in centimeters. How do I make it display as inches?
|
| Excel Save a number on open | 02 Mar 2005 19:15 GMT | 11 |
Good Afternoon all, I am looking for a template that when I open the file it automatically increments a cell by 1. Any thoughts or ideas?
 Signature SCOTT ROWE
|
| what is function vs. formula? | 02 Mar 2005 18:38 GMT | 3 |
my question is what is function vs. formula? I need to know so that I can study for finals. I'm trying to get as much information as I can on the subject so that I may possibly get a good grade
|
| Printing floating point numbers | 02 Mar 2005 17:52 GMT | 4 |
Here is a problem I am like help with regard to rounding in excel. 4.4 is rounded to 4. So 4.4 + 4.4 = 8.8 which is correctly rounded to 9. When this is printed, the user sees 4 + 4 = 9. Clearly, this has the tendency to confuse. I would like to avoid rounding when printing and I
|
| How do I add 2 leading 0s to a list of numbers | 02 Mar 2005 16:48 GMT | 1 |
I have a list of numbers, how do I add 2 leading 0s (zeros) to this list of #s? Thanks much, you folks are great! Lakedawgs
|
| function slef | 02 Mar 2005 16:27 GMT | 2 |
i have a quick question. if i click in a cell with a lot of text, it will show up in the Fx (function) slef. the problem is that it takes up half the screen. is there a way to turn off showing text in the function slef, when clicking in a cell?
|
| Retaing a varialbe between running the same macro | 02 Mar 2005 16:13 GMT | 1 |
Over my head here? You betcha! I have put together a macro that examines the colorIndex of a cell and stores it in an integer variable called intial_cell_color. the macro then changes the color index of that cell and exits. I need to be able
|
| I need to remove the hyphen in a list of #s | 02 Mar 2005 15:32 GMT | 4 |
I have a list of numbers as shown 12345-67 12354-58 15454-54
|
| convert seconds to timecode format | 02 Mar 2005 14:52 GMT | 2 |
In C1 through to C800 i have values which represent seconds. (time) HOw can i convert that into 00:00:00:000 hours: mins: secs: fraction of secs
|
| Using Macro to Alter Multiple Pivot Tables | 02 Mar 2005 13:49 GMT | 1 |
I recently posted a question about "...how to use a macro to alter a Pivot Tabel". Debrah gave me a sollution which worked perfectly :-D Though I wanted more... I tried to alter two Pivot Tables at the same time. And it worked splenditly! :-D
|
| New Line with Concatenation | 02 Mar 2005 13:42 GMT | 3 |
I enter the follow with <alt+enter> after the word Date to get the following in cell A1: Todays Date 03/02/05
|
| How to 3D Chart? | 02 Mar 2005 13:18 GMT | 1 |
I want to show this date as point in 3D chart. 3 unit is axis of X,Y,Z. (I can make more than 3 axis of chart?) Thanks.
|
| Formatting Form Elements | 02 Mar 2005 12:35 GMT | 3 |
I have a couple of form elements on my worksheet, (combo box, list box etc.) that are working nicely, one question however: how do I format the font size, type etc. in these ?? Excel 2000, Win XP.
|
| Excel not opening file | 02 Mar 2005 09:24 GMT | 3 |
I am running Excel XP and have a strange problem. When I double click an excel file to open it, Excel fires up okay but doesn't open the file. I have to then open it manually. The file association is correct because it opens excel. I have tried removing Office XP and reloading .. ...
|
| Calendar Creation in Excel | 02 Mar 2005 09:23 GMT | 7 |
I was tasked with creating a calendar in Excel, that could then be printed and used in our department. The calendar had to be created to specific requirements: 1. The last three months of 2004 had to be included;
|