| Thread | Last Post | Replies |
|
| How do I create a macro to add zeros in front of a value? | 20 Sep 2006 01:54 GMT | 8 |
PLEASE SOMEONE HELP ME!!! I have to add zeros to over 61,000 line items in excel. I need to know how to create a macro that will enable me to select a range within the same column and have zeros added to the the numbers in the cell.
|
| how do i change a case to proper text in excel 2003 | 20 Sep 2006 01:21 GMT | 1 |
Please help, I need someone to help me change case to proper cases on an excel spreadsheet.
|
| Result = to 0 says false | 20 Sep 2006 01:04 GMT | 5 |
I am pulling my hair out at this point and need some help. I have a worksheet with many cells and calculations. I have calculations performing on results of a calculation. In then end of all of this I have a If statement that says IF(Y4=0,"Yes","No")
|
| Entering formulas | 20 Sep 2006 00:11 GMT | 1 |
I have a column that I want to reflect a 2% commission when I enter the sale amount into the cell. How do I accomplish this?
|
| How do I conditional format by referencing failure/success? | 19 Sep 2006 23:41 GMT | 2 |
How do I conditional format a cell by referencing another workbook's failure/success outcome? Here's what I have: Workbook #1 = a fax list with customer IDs and fax numbers
|
| how do I edit an embedded spreadsheet? | 19 Sep 2006 23:14 GMT | 6 |
I recently received a "leads list", created in Excel, which consists of one spreadsheet embedded into another. The embedded spreadsheet appears to be very large (over 1000 printed pages) and contains a lot of irrelevant information that I would like to edit out, however, I am ...
|
| adding cells | 19 Sep 2006 23:10 GMT | 1 |
how do I add cells within a cell that is used as a function
|
| multiplication | 19 Sep 2006 23:07 GMT | 2 |
Help all I am trying to do is multiply two cells together. Cell one is 50.00 and cell two is 0.50 this should equal $25.00 All that keeps showing is the formula. Help gives me this formula: PRODUCT(E10:F10)
|
| Cell Calculation | 19 Sep 2006 22:58 GMT | 5 |
I am setting up a input sheet for fees. I have two cells side by side: one where a dollar amount will be entered and the other with a drop menu. I need for the dollar amounts to be calculated based on the drop down item chosen. For example, if the dollar
|
| How to merge monthly workbooks into a quarterly workbook?? | 19 Sep 2006 22:56 GMT | 6 |
I do a monthly 3 sheet profit and loss sheet in excel for my employers company and now he wants me to make a quarterly and yearly sheet combining 3 workbooks (or 12 for the yearly) into one. Is there any way to achieve this by merging workbooks andif so how???? Please help!!!
|
| Database Analysis Question | 19 Sep 2006 22:29 GMT | 3 |
I have the following Column A B C D E F G Row 1 Z Y X W V U
|
| COUNTIF by days of week | 19 Sep 2006 22:25 GMT | 7 |
I have three columns of data as shown below, but for the entire year: A B C 08/01/06 Tue 2999.78 08/02/06 Wed 3283.59
|
| Lookup and Replace | 19 Sep 2006 22:15 GMT | 3 |
I need some help in creating a look up to replace some data in my spreadsheet. I had thought about using Access, but need to keep the cell's in the format that they are in, and so cannot accurately import the data into Access for manipulation.
|
| How do I copy and paste a worksheet and maintain all formatting? | 19 Sep 2006 22:08 GMT | 2 |
I have formatted one worksheet to use weekly. Everytime I copy and paste it for a new week, I lose some of the formatting. How can I maintain every change that has been made so I can copy and begin data entry without reformatting?
|
| function to change cell position and allows dragging | 19 Sep 2006 22:07 GMT | 2 |
I want to enter a formula that will reference a particular cell, and then allow me to drag the formula down so it references every third cell. So, if my data is: A
|