| Thread | Last Post | Replies |
|
| Changing the font in a check box | 20 Mar 2008 21:38 GMT | 3 |
I'm trying to change the font in a check box created from the 'Forms Toolbar', is it possible to change it and if it is how can i go about doing so? Thank you in advance!!
|
| Excel Email Attachment Save As Root Directory | 20 Mar 2008 21:02 GMT | 2 |
When I receive an Excel or Word attachment and open, since it is a temp file, when I do a Save As, it defaults to that location. Since I have Excel and Word set up with root directories, why won't email attachments default to those locations when doing a Save As? Is there any ...
|
| Why is trace precedents disabled in Excel 2007 | 20 Mar 2008 20:44 GMT | 2 |
I don't know what's wrong. it's a simple spreadsheet. I love that MS makes something easy difficult. If anyone knows how to enable this on simple spreadsheets that would be great, if you also have some idea why I had to waste a bunch of time finding out how to do something ...
|
| Different Versions of Excel | 20 Mar 2008 20:42 GMT | 2 |
How can I view a document that was made in Excel 2007 in Excel 2003?
|
| cell data validation | 20 Mar 2008 20:39 GMT | 2 |
in one Excel2003 task I have some cells linked to a code list to get the data validation. The codes in the list are numbers or mixed numbers and letters. The mixed codes can be indifferenctly selected from the dropdown list in the
|
| Week number date formula | 20 Mar 2008 20:27 GMT | 8 |
I'm trying to write a formula to show the date where 20/03/2008 would show as W3Thur and 31/03/08 would show as W5Mon and 01/04/2008 would show as W1Tue. I have A1= 20/03/2008 and B1= "W"&weeknum(workday(a1,0),1)/4&text
|
| Counting Problem | 20 Mar 2008 19:59 GMT | 2 |
I am trying to count all the numbers in a column that equal or exceed a number that is entered manually in an individual cell (A1). But the countif function does not work unless I enter the number directly into the formula. For example:
|
| Weird formula malfunction, has anyone seen this before? | 20 Mar 2008 19:54 GMT | 2 |
I have Excel 2003 I have a number of different workbooks with forumulas in them. Today I was entering info into one of them and they weren't averaging as they're supposed to. The cells with the averages just remained blank although when I clicked
|
| TIMESTAMPING AMENDMENTS? | 20 Mar 2008 19:35 GMT | 1 |
Is there a way that when a cell in colmun A is edited, its corresponding cell in column D displays the time the edit took place? any help or advice welcome, thanks,
|
| large conditional "if" query | 20 Mar 2008 18:48 GMT | 5 |
i have data keyed by user into cells in column B, dependent on which column C should autofill its corresponding cell with one of several things. if col b cell equal any of the following values i need corresponding column C cell to show "R2PF"
|
| how to print a form multiple times on one page | 20 Mar 2008 18:37 GMT | 3 |
I have a small form that I would like to print multiple times on one piece of paper. The form is only 4 lines by 3 columns, so I figure 10 copies would fit on one page. But I do not want to copy the form 10 times, if I do not have to that is. Any suggestions on how I might do ...
|
| Why can't I see cell shading on worksheet? | 20 Mar 2008 18:20 GMT | 1 |
I have never had this problem when working in Excel before. I have a new laptop for work. I have not programed it myself our IT guy did. I am able to format cell shading but I can't see the color or the change unless I view print preview. It's bizarre. I am sure it is something ...
|
| can anyone tell me how to set excel to open to a specific folder | 20 Mar 2008 18:14 GMT | 1 |
can anyone tell me how to set excel to open to a specific folder
|
| Extract surname from forenames | 20 Mar 2008 18:07 GMT | 7 |
I have a long list of names that I want to break down into Surname/Forenames. I have used an IF statement to get out the surname after using Text to Cols to breakdown the data. I now need to separate out all other names - any idea how to do this?
|
| Extract a specific portion of text as new cell value | 20 Mar 2008 18:06 GMT | 6 |
I have a question for the excel masters. (genuflect) If I have a list of values in a list that contain some unwanted text. For example: (jblow)
|