| Thread | Last Post | Replies |
|
| Can I prevent Excel converting to date format? | 06 Sep 2005 20:33 GMT | 6 |
I was wondering if there was a setting or any way to prevent Excel from converting certain numbers to dates. e.g. 11/7 will be converted automatically to 11/07/2005. This appears as 11-Jul in the cell. This problem also happens with 11-7.
|
| Custom # format | 06 Sep 2005 20:21 GMT | 1 |
I would like to display a number * 100, a percentage w/o the percent sign. For example, if I type in .55 I want the sheet to display the number as 55. How can I do this? Thanks
|
| Trouble with a keyboard shortcut | 06 Sep 2005 20:20 GMT | 1 |
I am helping a coworker that is having a strange issue in Excel. A row of data from an old spreadsheet has somehow been copied, an every time she hit the "3" key, while in a new or any existing Exce worksheet, this copied row from the first worksheet is inserted o
|
| Using Relative Hyperlinks | 06 Sep 2005 19:12 GMT | 5 |
How would one set up relative hyperlinks in Excel? For example, if the links refer to a file system directory, so that the whole hyperlink would be <base directory>/<variable part of filename>, how could one set things up so that if the <base directory> were to change, one could ...
|
| Generating run tim error | 06 Sep 2005 19:00 GMT | 1 |
I am wondering if there is anyone that has run into this before. Here is some code that is in one of my macros. Sub terr_100() ChDir "\\dynamics\Documents\Terry\EOD_REPORTS"
|
| Hiding rows that are not grouped | 06 Sep 2005 18:49 GMT | 2 |
I want to hide or unhide all the rows with n/a in column F. Does anyone know of an easy way to do that? Thanks, Michele
|
| Make Excel default to certain worksheet on startup | 06 Sep 2005 18:41 GMT | 3 |
Just wondering if there is a way to force excel to display a certain worksheet upon opening a document regardless of which worksheet was viewed last. I have a document with about 75 different worksheets and have made a
|
| Add a tick in a cell | 06 Sep 2005 16:34 GMT | 2 |
I want to add a tick sign in a cell, but I don't know where to find a tick sign. Anyone can help ? et
|
| Find all and Sum | 06 Sep 2005 14:49 GMT | 2 |
I have created a worksheet of new/lost and sales moved from one vendor to another with the associated sales people. New Date Customer Name Type Vendor Premium Commission SalesPerson
|
| Filter out data | 06 Sep 2005 13:26 GMT | 1 |
i am working on a workbok and have some sheets with a list of data. This is a product list. Looks like: Dimensjon | Text | Type | Number | And some mor
|
| Grouping data and protecting worksheets | 06 Sep 2005 13:18 GMT | 5 |
I have grouped a number of rows in my excel sheet so I can collapse the rows into 1 row. I then want to protect the worksheet from end users however I also want them to be able to expand and collapse the group with the small grey plus/minus
|
| Combobox display on startup | 06 Sep 2005 13:02 GMT | 5 |
Hi There is probably a very simple answer to this but I can't find it... I have designed a spreadsheet were the end user can select the data to view by selecting the Year from a range of years and Category from a range of
|
| how to make a picture pop-up when selecting a cell? | 06 Sep 2005 12:47 GMT | 1 |
hello, is there a way to configure a cell such that when clicked, small window will pop-up, displaying a picture of your choice -- tendercar
|
| excel search function | 06 Sep 2005 08:50 GMT | 2 |
i created a big excel file with many sheets. in every sheet (except sheet 1 and 2) is a special id number in column B. now i want to make a search function on sheet 1 to get linked to the sheet (cell) where the number-which i`m looking for, is. how can i do this?
|
| sharing totals between worksheets | 06 Sep 2005 08:01 GMT | 1 |
Hi, HELP! I am trying to create a worksheet to balance our household income and expenses. What I need to do is take a running total from one worksheet and have it automatically reflect changes in another worksheet. I don't know the proper terms for this action. So to try spell it ...
|