| Thread | Last Post | Replies |
|
| font size in checkbox (this is an easy one!!!) | 19 Oct 2004 21:48 GMT | 1 |
I am lost on how to change the font size for the text associated with my checkbox. I have went through "Format Control" and even tried changing font size on the worksheet before creating the checkbox, but everytime I try to create this simple check box the font that lays next to ...
|
| 11-5678 turned into Nov-78? | 19 Oct 2004 21:00 GMT | 1 |
Thanks Peo and Bernie! In fact this is our office extensions. Apart from 11-xxxx we also hav 12-xxxx. I'm trying to display employee contact info on a Web page, then use a
|
| Text and numbers | 19 Oct 2004 20:52 GMT | 2 |
I'm working on a job applicant scoring system. I would like for any text that I type to represent a number value that I choose, so that I can score applicants.
|
| how to convert week number to month | 19 Oct 2004 20:49 GMT | 2 |
how to convert a week number (say 43) to the corresponding month (sa October)? best, Fren
|
| SUM formula automatically updating | 19 Oct 2004 19:39 GMT | 1 |
I have a spreadsheet that has January in column D thru December i column O. My formula in column P is only for year to date numbers, s I have the formula =SUM(D1:L1)
|
| Lookups across different spreadsheets | 19 Oct 2004 19:32 GMT | 2 |
I want to do vlookups for a particular expense account across multipl worksheets, each of which represents a different cost center. So o my summary main worksheet, I have column A as shown below. 8600 is a account number. In column B I want to add up all the occurrences o
|
| Problem with scrolling | 19 Oct 2004 19:02 GMT | 1 |
I'm using Office 2000 on XP pro. In excel, when I move the scrolling bars with the mouse, the spreadsheet does not scroll to the new position until I release the mouse. This does not happen in Word or any other applications. It makes it difficult to see how far down I'm
|
| 11-5678 turned into Nov-78? | 19 Oct 2004 18:36 GMT | 2 |
I tried to format the cell with a custom format 00-0000. It won't help. Could you give me some help? Thanks a lot -- newusere
|
| Updating links that use SUMIF | 19 Oct 2004 18:28 GMT | 2 |
I am having a problem a link to another workbook. The link uses SUMI formulas. When I go into the destination workbook, I hit update file. The formula becomes #VALUE. I go under Edit/Links (using Check Status Update Values) and it remains #VALUE. The odd thing is that when I hi
|
| help me understand excel!!!!!!!!!!!!!! | 19 Oct 2004 18:18 GMT | 4 |
My job needs input info.... plzzzzzzz if you can help...........
|
| Formatting in Formula | 19 Oct 2004 16:25 GMT | 6 |
Hi, I am trying to concatenate a few columns but having trouble with number format Column A: ABCDEF Column B: 015 (this col is formatted with 'Number 000')
|
| Transforming a col of text strings to hyperlinks | 19 Oct 2004 15:45 GMT | 1 |
I have a column with various internet hyperlinks. However for som reason they are stored in the column as ordinary text strings. Is ther a way of transforming all the strings to hyperlinks --
|
| Sum Non Grouped Data | 19 Oct 2004 15:39 GMT | 1 |
I have a spread which stores past and present data. I want to be able to show a sum of the data that is visible before and after grouping is applied. I have some code which runs when an autofilter is used (see below), but this doesnt work for grouping.
|
| Skill of dragging the little cross | 19 Oct 2004 15:13 GMT | 3 |
I'm using Excel 2003 to generate a sheet like following. A1 is the only "price", which I could change the value. From B1 to B200, perhaps, the cells show the quantities. Cells from C1 to C200 show the costs, which is always Cost multiplied by
|
| filtering data into different workheet | 19 Oct 2004 15:03 GMT | 1 |
I would be most grateful if someone could please help me out here? I have a huge spreadsheet with 1600 rows, column 'A' containes 2 different categories i.e. fuel gas, produced water, gas export, etc. also have anoher column which is 'C' this states the last inspectio
|