| Thread | Last Post | Replies |
|
| Cell formatting | 17 Feb 2005 21:30 GMT | 1 |
I cannot get my cells to format correctly. When I type text in a cell it automatically truncates instead of overrunning into the next cell. I've already looked at the format cell settings and all the boxes are unchecked. Any suggestions? Thanks!
|
| sorting(?) problem | 17 Feb 2005 21:08 GMT | 1 |
I have problems generating a rutine that will automatically sort my sheet. The sheet is in this format (always 2 columns only the rows may vary) a 1
|
| sorting problem | 17 Feb 2005 21:07 GMT | 3 |
I have problems generating a rutine that will automatically sort my sheet. The sheet is in this format (always 2 columns only the rows may vary) a 1
|
| If/then to print text. | 17 Feb 2005 20:44 GMT | 2 |
I want to use a formula so that when a value over zero is put into one cell, a line of text prints in another cell. I know it is an if then function, but I've forgotten the exact formula and the way to encode the text message in the formula.
|
| Hiding rows but retaing the information | 17 Feb 2005 20:25 GMT | 2 |
The problem I have is, I have three rows, with row #3 three having filters along about fifty columns.I wish to hide row #4 to #18 and keep rows #19 to #60 unhidden. However, when I hide #4 to #18, it appears to hide the information to the
|
| Ignore DIV/0 Errors in Array? | 17 Feb 2005 20:23 GMT | 3 |
Hi all... I've got a spreadsheet that looks something like this: Score1 Score2 AvgScore 1 1 1
|
| cell format | 17 Feb 2005 20:15 GMT | 1 |
I have to convert the cell format from .123 to 0,123, how does it work?! Thanx!
|
| How Do I create a worksheet with rows and columns | 17 Feb 2005 19:43 GMT | 4 |
I need help in creating a document with rows/ columns in Excell, I havice Microsoft Office 2003
|
| Conditional Format | 17 Feb 2005 19:13 GMT | 2 |
Can someone help me with this conditional format problem? I am trying to express the following: If the number in cell B3 can be found in the range J1:O1, then the condition is true.
|
| List employees with hours worked, weekly, quarterly, and annually | 17 Feb 2005 18:41 GMT | 6 |
I need some help!! I have been teaching myself how to use Excel, and I am getting there. Our company has 21 employees. I have to create a listing that will show the hours for each employee, regular, overtime and double overtime. It has to be able to show, weekly totals, quarterly ...
|
| Forced Format | 17 Feb 2005 17:27 GMT | 2 |
I'm needing to have another user fill in a field of SSN's for their people on a document. However I can format the field to be special or custom and it will correctly show 000-00-0000. Problem is they can enter the following errors and it will display the result (see below ...
|
| Clearing data | 17 Feb 2005 17:02 GMT | 3 |
I've got an excel spreadsheet with a column of 120 names. each name has columns of stats that were entered weekly and have summary columns. The league ran for 22 weeks.
|
| Cannot find macro | 17 Feb 2005 17:02 GMT | 2 |
I was alerted when I was opening an excel sheet that there were macros. The file was originally created by another person. However, when I went in and tried to delete them, I did not see any macro listed. Where can I find these macros?
|
| Index and Match | 17 Feb 2005 16:55 GMT | 4 |
OK, here's my question. I have a list of a set of values listed below: REP Total John 12500
|
| Writing to the properties of a file | 17 Feb 2005 16:49 GMT | 1 |
When you right click on an excel file you can go into the properties section where there is a spot for comments and general things like that. I'm wondering how you could write to this using VB 6.0. Thanks!
|