| Thread | Last Post | Replies |
|
| Excel displaying values incorrectly | 11 May 2005 13:14 GMT | 3 |
I am trying to open this xml file with excel but it isnt displaying the number correctly: <?xml version="1.0" ?> <ps>
|
| delete single space | 11 May 2005 12:57 GMT | 1 |
please help how can i delete the space in a text box e.g. cloumn a
|
| how to control the size of a comment shape | 11 May 2005 12:54 GMT | 1 |
i wonder how to control the size of a comment i added in a cell with vba. i failed all, thanks
|
| This is a doozy... | 11 May 2005 12:52 GMT | 1 |
I don't even know where to begin with this one. I have information that needs to go into some form of a chart--any chart. I need to show the number of departments in several buildings that are compliant with rules from Jan thru April. Basically, from what I can see, I need to ...
|
| Want the cell blank | 11 May 2005 11:50 GMT | 7 |
Using Excel 2000. I have a formula below. If the cells D41 and E41 are blank, it returns this #DIV/0! I would like the cell to be blank if there is no info in it. How do I do that? =D41/E41
|
| trim | 11 May 2005 11:10 GMT | 4 |
I am struggling with Trim. Please can somebody advise me step by step what I should do to remove an unwanted space from text entries. I have a column which is approx 2000 rows long, and quite a few of the cells have a space before the text (ie on the left hand side of the text) ...
|
| Data Validation | 11 May 2005 10:51 GMT | 2 |
Hope some genius out there can help. I need to ensure that users enter a numeric value in the current cell of a range of cells. I've attempted to use the "Data Validation" feature of Excel but do not want to restrict the user to a particular range of numbers, but
|
| Need to change text to csv | 11 May 2005 10:09 GMT | 3 |
My credit card company has an export feature. One of the options is ".csv (Excel). This used to give me a nice clean spreadsheet with each column of information in a separate Excell column. I guess it converted on the fly or something. But now it seems to be a "comma ...
|
| Comparing two lists | 10 May 2005 23:54 GMT | 5 |
I have two lists in a workbook, each on there own sheet. I want to find if the value of on cell in list "A" has an exact match in list "B". Also how can I strip all characters preceding the character "/" in a cell and also remove the space that is right after the character "/"?
|
| excel formatting | 10 May 2005 23:20 GMT | 3 |
i have a spreadsheet that lists by salesman po's and their value. how do i create a formula so that i can add all the rows just for a particular salesman. i do have the drop down list on the salesman header.
|
| How do you do 'if' statements? | 10 May 2005 23:02 GMT | 5 |
On sheet 1, column B, Line 27, I have to enter 'M' or 'F'. On sheet 1, column B, Line 28, I enter an age. '54'. I need on sheet 1, column C, to populate the health rate based on the criteria entered, 'M/F' and 'age'.
|
| creating macro | 10 May 2005 21:30 GMT | 2 |
I know very little about VB in Excel but I've gone through the "Record New Macro" to copy several different fields in different rows to a single row and several columns. The problem I have is the macro always runs against the same data in the
|
| pie charting through excel, using power point | 10 May 2005 21:00 GMT | 2 |
Hello~ I am working on a presentation for class. We used a yes and no survey, I think I figured out how to pie chart. But, now I want to insert that into power point. How do I do that. I go through INSERT, PICTURE, then I click
|
| non numeric pie charting | 10 May 2005 20:30 GMT | 1 |
Hello~ I have conducted a survey of five questions being yes or no questions. I need to figure out how to put my results into a pie chart. I saw on an earlier thread where you need to do a pivot table. This is my first time
|
| Problem with Protection and Hyperlinks | 10 May 2005 19:58 GMT | 2 |
I am having a problem with protecting a worksheet that has hyperlinks in it. I have set the cell protection so that only the three or four cells with hyperlinks can be selected. When I turn on protection on this sheet and someone tries to select a protected cell it acts like
|