| Thread | Last Post | Replies |
|
| introductions | 18 Jul 2006 22:45 GMT | 2 |
I hope this is the place to introduce myself. I am vircats. Hi t everybody. I am glad to meet you. I am new here, still don't know m way around, sorry --
|
| simple question on splitting cells | 18 Jul 2006 22:13 GMT | 5 |
How do I split a small group of cells into a number of different column without affecting the rest of the cells on the sheet? Is this eve possible? I have is six rows, and I want to split the first column of all o
|
| An Operational Problem | 18 Jul 2006 21:38 GMT | 4 |
Using Excel 2002, Excel will not maintain toolbar customizations and will also not close properly. 1. If a button is added to a toolbar, it functions properly, but when Excel is closed and then relaunched, the new button has vanished. Found and
|
| Large integers in cells | 18 Jul 2006 21:31 GMT | 6 |
How can I make Excel show integers larger than 15 digits? I mean without showing it in squares of 10. 123456789012345 is largest I can make fully visible by changing cell type. After that, for example 1234567890123456 is shown as
|
| date subtraction difficulty | 18 Jul 2006 18:59 GMT | 1 |
I'm trying to subtract dates, to calculate time duration. I'm subtracting column A from column B into column C. Column C is formatted 'm "mos", dd "days"' and columns A and B are formatted 'mm/dd/yy/@' Unfortunately each of the durations is 1 month too
|
| loading data from access in vba | 18 Jul 2006 18:35 GMT | 2 |
How can I load a database from an Access Application in VBA? I tried with GetObject function, but I don't know how to get the database. Remy
|
| Stock Inventory | 18 Jul 2006 17:56 GMT | 2 |
Dear Sir, Is it possible in Excel that by just encoding the data in receive and issue voucher it will automatically post in STOCK CARD worksheet and then automatically update in the MATERIALS INVENTORY worksheet: See my sample
|
| Create a numerical sequence in a column: From 1 to .... | 18 Jul 2006 17:46 GMT | 3 |
I want to automatically generate a sequence of numbers from 1 to....X without typing them all. How?
|
| Hiding a Zero Result | 18 Jul 2006 17:23 GMT | 5 |
I am adding/subtracting cells C3 to J3 along a row with the result showing in K3. When nothing is entered K3 shows a zero which I want to hide so when I copy down the sheet to 52 weeks I don't have a column full of zeros. I have tried =IF(C3:J3=0," ",C3:J3) and =IF(C3:J3=" "," " ...
|
| HELP WITH FORMULA PROBLEMS | 18 Jul 2006 17:23 GMT | 1 |
WHENEVER I TRY TO ADD INFORMATION TO AN EXISTING FORMULA OR CREATE A NEW FORMULA THE FORMULA APPEARS INSTEAD OF THE REULT EXISTING FORMULAS ALL SHOW THE RESULT HOWEVER, ALSO SOME OF THE FORMULAS ARE NOT COUNTING THE CORRECT VALUE OR SUMMING UP TO THE CORRECT FIGURE
|
| How can I get auto sum of column when new figures are added | 18 Jul 2006 17:21 GMT | 2 |
I have put in formula to total a column of figures, it has empty cells for new items to be entered as they occur. It used to total in new items automatically, now it will not total in new items. It is a Monthly spreadsheet. I used" create a copy "to make blank copies to use for ...
|
| Sharing workbook | 18 Jul 2006 17:19 GMT | 1 |
An excel file was shared by selecting "Tool/Share Workbook.." menu item At the same time the folder in which the file is located is set wit "permission" at "full control". On opening the file, the status seen i "(read only) (shared)". How do I get rid of the "read only" status. Al
|
| Can it do this? Don't know what its called! | 18 Jul 2006 16:45 GMT | 5 |
Im new to excel and was wondering about the following: In one of the columns i have to put the same information except for the number at the end, eg example1, example2, example3 etc. Is there something on excel that will add what i want with the number
|
| make the cell hyperlink to any name within it | 18 Jul 2006 15:23 GMT | 2 |
is it possible to make the hyperlink relevent to the text within a cell. i.e if the cell said paul it would email to pauls email address or if the same cell said mark it would email to marks email address and so on.
|
| Can you sort the worksheets in a workbook | 18 Jul 2006 14:23 GMT | 2 |
In my workbook I have about 70 worksheets, but I want them i alphabetical order. Is there a quick way I can do this by selecting al sheets and then sorting, or do I really have to go into each one and d it manually
|