| Thread | Last Post | Replies |
|
| Inserting a column of date automatically | 14 Sep 2006 14:25 GMT | 2 |
I want to chart some data on a daily basis and I started a worksheet to do this. The first column will show the date. Rather than enter the date every day, I am hoping there is a way to automatically have the date inserted into each cell in the first column,
|
| A lot of Text Boxes! | 14 Sep 2006 13:38 GMT | 7 |
I got a problem on my excel files. Hope you may help. I don't know why, many of my excel files have a huge number of Text Boxes. It's over 50,000 and they're all empty. As a result, it slows down my computer. Whenever I edit the files, it takes more than 10 seconds to
|
| VBScript Excel formatcondition cell: syntax | 14 Sep 2006 12:37 GMT | 2 |
I'am working on a VBScript that fills a Excel-sheet with data from text-files The following code should create condition formating within a cell: Wiith oWorkbook.cells(Regel, cColBGCount+dicbg.Count+1)
|
| find | 14 Sep 2006 10:29 GMT | 3 |
How can I setup a macro or use a function to find a column who's first cell is called "Addresses" then move the whole column to sheet 2. Is it possible? Puzzled
|
| How to sort with merged rows | 14 Sep 2006 09:38 GMT | 6 |
This is my delema. I have data that I need to input. At the same time I would like to have a blank area below each contact so that I can add notes. The first problem is that when I try to sort, excel keeps saying "this operation requires the merged cells to be identically ...
|
| Formatting a number in a cell with text and number | 14 Sep 2006 09:22 GMT | 4 |
I have a cell with the following entered in it: ="Daily Average = "&E2 The value of E2 diplays with all the decimal points showing. I need to format the value of E2 to display with no decimal points showing, such
|
| Formula request | 14 Sep 2006 08:51 GMT | 2 |
I am trying to set up a formula each time the data changes in column A without having to do it manually. The formula would be using two other columns of data for the rows involved with the same company.
|
| How do I force trailing zeros in an Excel cell? | 14 Sep 2006 08:43 GMT | 8 |
My accounting people have set up an excel spread sheet. woth part numbers. Many of them end in a "0". Ex; 2211.11520 and if you click on a cell with a number ending in 0 , the zero goes away on the edit line.
|
| If statement with dates | 14 Sep 2006 08:27 GMT | 5 |
I'm using Excel2003 with sp2. I want to track expiration dates of memberships I want to say: If m3 is blank make N3 blank and if M3 has a date, make N3 one year later. How do I do this?
|
| Formatting decimal numbers as time - no conversion to time | 14 Sep 2006 05:08 GMT | 3 |
I have a timesheet that's used for payroll purposes. The sheet is about as simple as it can get. I would like to be able to enter the time worked for XXXXXX as a decimal number and have it display as hours and minutes. For example:
|
| Odd error - "This operation requires merged cells..." | 14 Sep 2006 01:54 GMT | 3 |
I'm cutting data from multiple sheets and pasting it into one, using Paste Values. This has been going OK for a while, but then when I cut data from one of the sheets, I get the error: This operation requires the merged cells to be identically sized.
|
| hide ranges? | 14 Sep 2006 00:54 GMT | 1 |
Is there a way to make certain ranges of pages hidden so that either they must be unlocked with a password or only certian users can view/edit them?
|
| Excel help | 14 Sep 2006 00:01 GMT | 3 |
I want 5% of one cell $ amount to automatically post to another cell. Is this possible? Or do I need to it manually and enter in the info in the new cell?
|
| is it possible to show a cell value using IF(AND function | 13 Sep 2006 23:54 GMT | 4 |
I would like to show the value of Cell A1 in Cell A3 , what do I need to replace "=A1" portion of formula The cell format is set for numbers and there is also some conditional formating
|
| Fun trying to convert xls to document everyone can open! | 13 Sep 2006 22:26 GMT | 4 |
I have Office 2003 and created spreadsheet for class schedule that I could use formulas, hide columns, etc. Excel seemed to have more advantages over keeping it in MS Word. However, not everyone has Excel so I have had fun trying to convert it. It is only a two page document ...
|