Threads Replies Last Post 125 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   cell format Why when entering a 12 digit number is the last digit is changed to a "0" when saving? An example would be entering the number 123456789123 would be saved as 123456789120. Currently my cell format is general.... 3 29.08.2006 13:01:02 remove punctuation from address I need help removing commas, periods, parenthesis, dashes, etc from an address file a customer supplied to me. Below is one row for example. In order to dump the address file into our system, I need to remove the punctuation. Is there a formula that will do this for me? The Name, Company and address are each in a different cell. Ed Olsen, Sr Seattle Mill & Industrial Sup... 4 29.08.2006 12:53:02 How can I change a list of phone numbers into peoples names I have a large list of phone number from my phone bill which I have copied into Excel and I would like to somehow lookup the number in my phone book which is also in Excel and show the persons name from the phone number.... 3 29.08.2006 11:46:01 Should be a easy How do I I have a spreadsheet that I put Store names and addresses in the same cell (say E5), I need a formula so that if E5 contains "Target" or "CVS" that in cell F6 it will return a number. Should be easy can someone please show me the formula? Thanks ... 10 29.08.2006 07:53:36 Edate problems I am having problems wtih getting the correct date. My start date is 03/12/06 in cell C4 and I want to calculate 6 calendar months from that date into another cell. All I end up with is 09/12/06, when it should be done in regular calendar months. The answer should be 09/21/06 but I don't know how to get the formula to get that date. I tried using just the date function and then tried eda... 5 28.08.2006 20:34:02 how do i select data based on two inputs in excel Pressure Psig Inlet Temperature 90 95 100 105 110 115 120 60 1.156 1.289 1.451 1.643 1.915 2.296 2.793 70 1.022 1.140 1.283 1.453 1.694 2.030 2.470 80 0.929 1.039 1.166 1.320 1.539 1.844 2.244 90 0.855 0.954 1.074 1.216 1.417 1.699 2.067 100 0.797 0.888 1.000 1.132 1.320 1.582 1.925 110 0.742 0.828 0.932 1.055 1.230 1.474 1.793 120 0.700 0.775 0.872 0.987 ... 4 28.08.2006 17:34:02 Formatting Protection Hi I run Win2K with Excel 2K I have a spreadsheet that is protected. Some cells on the sheet are not protected so that data can be entered. The problem I have is that sometimes people copy and paste this data from an external source and this results in the formatting for the cell to be changed. What I would like to know is there any way which I can have the spreadsheet protected a... 2 28.08.2006 08:18:50 how do I change font size in a dropdown menu I created? The size of the font in the dropdown menu I created is very small so is there any way of making it larger? Any help much appreciated thanks... 2 27.08.2006 22:08:56 Drop Down List in Excel Hello, I need to analyse survey data in excel. I can make a drop down list in Excel, via Validation, and get the option to enter one choice. However, one question asks respondents to select "all" that apply. I do not know how to do this, there are anything from one to six selections. The ideal choice would be to be able to selct more than one rather than have to enter each choice as... 9 27.08.2006 15:39:16 Import external data in protected worksheet Is there any way to import external data in worksheet that is protected?... 4 27.08.2006 01:20:01 time from minutes to decimals I want change the time in my worksheet. I need change 3:30 to 3.5 decimals numbers... 4 26.08.2006 08:40:14 Cell reference I would like my macro to selelct a cell referenced by another cell. For example the value of a formula in A1 is (so cell A1 reads "C4") so i would like to find a way to automatically (macro or VB code) that will select the refrenced cell C4. Any help is much appreciated. ... 2 26.08.2006 06:37:25 download excel How do I load excel onto my windows xp computer?... 6 25.08.2006 19:39:45 How do I insert a photo from my documant into my work sheet? How do I insert a photo from my documant into my work sheet?... 3 25.08.2006 19:00:01 How to prevent any one from opening my workbook I created a personal data workbook stored in my company network. I do not want any one in the office to be able to open it and read it. The "Protect" feature under the Tools does NOT prevent someone from opening and reading the data (unless I am doing something wrong!). ... 6 25.08.2006 18:54:46 Can I set up a multiple selection drop down list? I am wondering if it possible to have a drop down list that allows more than one selection. Thanks for any help.... 5 25.08.2006 17:12:16 I am new to excel and to multiply three colums together then add I am new to excel and to multiply three colums together then add them together for a final answer in a box ... 7 25.08.2006 15:53:24 What is the Excel formula for adding 1 column with several rows? I need to the sum of one column - several rows. Example: Column J rows 3 thru 71 without entering each column and row number.... 4 24.08.2006 22:16:12 Automatic filter ? I have a list of a couple of thousand (and more) individual items. I want to have a box for users to type in text (there are no numbers) and the results will be seen automatically reducing in number as more text is entered eg, typing A (or a) will show all entries beginning with A (without pressing "Enter" or similar typing AB will show only entries beinning with AB typing ABO wil... 2 24.08.2006 20:16:41 Splitting one column into two I have a spreadsheet which contains one column of names, (last name, first name). I would like to split this into two columns so that I will have the last name in one column and the first name in another so that I can use either the first or last name in a mail merge. Is there way to do this? Thanks-- BJ... 4 24.08.2006 19:50:29 PivotTable - cell format Hi, I have a PivotTable with two columns - student names and tuition. I highlighted the **grand total tuition** with fill color. Please note that only ONE cell had this format. However, when I changed the column of student names to a row of student names (by moving the "button"), all the tuition (and not just the grand total) had the fill color. Is this a bug? Is there a way to get ... 1 24.08.2006 19:45:54 How do I delete a macro when the workbook has been deleated? I am new at writing macros and I put some into my personal macro file, but i now need to delete them. The workbook they were in have been deleted, and when I try to delete then I get a erroe message telling me I can't edit a macro in a hidden workbook, unhide the macro.... 2 24.08.2006 19:42:03 Excel Columns Problem Hello Fellow Excel users, I have alittle problem which i hope somebody can point me in the right direction Picture my screen in excel Col A is a list of Names with Multiple entries for the same person Col B is a number ranging from 0 to 7 eg A B Joe Bloggs 1 Jim Smith 2 Joe Bloggs 4... 6 24.08.2006 19:32:37 Revised dates in excel How can I add a date that automatically updates every time it is opened excel (I can do it in Word, but not in excel... 3 24.08.2006 17:25:02 Template for Housing Society Maintenace Billing in India For Printing Housing Society Maintenace Billing in bulk.... 2 24.08.2006 16:33:20 125 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>