| Thread | Last Post | Replies |
|
| Function to indicate the amount of characters in a cell? | 27 Mar 2006 16:03 GMT | 2 |
Trying to do a conversion of data into a flat file. Using excel we have a column called Project Description. I want to run a function to ensure that the project descrption in each cell does not exceed 70 characters.
|
| Format Cell | 27 Mar 2006 13:37 GMT | 2 |
I like to acheive this dayte format in a Cell 27-Mar but also in the same cell ( add text) i.e "27 Mar (Chq)" At the moment I can only acheive 27/03/2006 (Chq) though the format is set to dd-mmm in format/custom
|
| Shareing a workbook with one user | 27 Mar 2006 13:36 GMT | 4 |
I have a workbook that I allow read only capability to nine other guys. One of these guys also needs update capability. How can I set it up to give one person update capability but the others read only capabilities.
|
| changing color of values bigger or smaller than target | 27 Mar 2006 13:28 GMT | 7 |
My question: I need to make a list for keeping track whether employees are of aren' making their targets, wich looks like this: SUBJECT[/B] *TARGET*
|
| HELP: text keeps on displaying ############## | 27 Mar 2006 13:10 GMT | 2 |
1. What is the maximum characters an Excel cell can take? I try to import a very large text string into an Excel cell. I notice that it's truncated to a certain maximum length. When I set the cell type to be TEXT it displays #########################
|
| Is a function or a number behind a cell? | 27 Mar 2006 11:05 GMT | 1 |
Lets say that in column A there are several typed in numbers (2, 5, 8 ect) and some functions that result in a number. By looking at this sheet you cannot tell wether there is a typed in number of function behind a cell. Is there a function that i can put in column B that can tell ...
|
| How to count cells | 27 Mar 2006 09:21 GMT | 3 |
I want to put a summary of Job orders in a table. (Excel (Zip) file attached) I am having a problem of total. I want to make a total of only approved job orders not the all job
|
| Cell colours and font colours | 27 Mar 2006 07:47 GMT | 8 |
I seem to remember that when you changed the cell to a very dark colour, the font automatically changed from black to white. My font setting is automatic colour but when I change the cell from no colour to black the cell contents do not display until I go and format the font to ...
|
| Merging with word | 27 Mar 2006 07:11 GMT | 1 |
Hello! I'm searching for a way to "link" a cell of information into a specific location into a MS word document. I was it was a simple as using the "=" sign and referencing the information I need like you can between two excel files. But I'm looking for a solution for
|
| unable to enter "/" in cell as 1st character | 27 Mar 2006 05:24 GMT | 3 |
Why am I unable to enter the forward slash character (as the 1st entry) in a cell? Instead, it appears to act like the ALT key, accessing the File menus.
|
| adding up values on another sheet problem | 27 Mar 2006 01:56 GMT | 4 |
I am trying to do some basic math from the values stored in another sheet, below is my attempt which brings back an error. Any help appreciated. thanks =EIsummary!SUM(C9:C15) =sheetName
|
| changing forumla results to values on the fly | 27 Mar 2006 01:25 GMT | 1 |
Is there a way to get a cell's forumla to convert to its resulting value on the fly (rather than having to go back in and cut>paste special>values)? Alternatively, is there a way to use a second column that will display the values returned from the formulas in the first column as ...
|
| New user with focused direction! Will Excel and VBA do it? | 26 Mar 2006 23:59 GMT | 1 |
First, the background - I am certain a code geek designed Newsgroup format and sign-up. Take a lesson from Yahoo. (This should seal my fate with the group.) OK, Debra, I'm here and on my feet, so far. I built my first userform with Debra's concise tutorial a couple weeks ago. ...
|
| Formatting of data detail on a new sheet from a Pivot Table | 26 Mar 2006 23:58 GMT | 2 |
I have Excel 2003 and have successfully created a Pivot Table which presents data as I need. However, when I double click one of the entries to give details of the entries which contribute to the data, the new sheet that's created doesn't retain the formatting of the original ...
|
| Link to Internet, copy paste data from Web Page | 26 Mar 2006 23:51 GMT | 1 |
I would like to be able to automate a task of clicking on a link in a spreadsheet and accessing specific data on a public internet web page (i.e. Address, City, State, Zip) and place this data into columns of the linked row. The data on the public internet web page is formatted
|