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  >>   Text Cut-off The text of my document is getting cut-off, especially the letters g and p. I am using CG Times, font size 12 with a row height of 14.5 in Excel on MS Office 2000. Any tips on how to get it to stop?? ... 4 01.09.2006 16:48:10 Importing an Excel Database How can I import an Excel database into my Yahoo! email address book? I created a rather large database that has a lot of email addys, along with a bunch of other fields (e.g., name, address, postal code, etc.). Anyway, I would like to import the names and email addys into my Yahoo! email program instead of having to retype the buggers. Is there a way to do this? Thanks. ... 2 01.09.2006 13:06:22 How do I get the microsoft office online taskpane excel to work? I have MS Office 2000 Small Business. How do I get the Microsoft Excel Help Task Pane to work,when working in excel?... 2 01.09.2006 12:06:02 I get a black square box on excel instead of the normal corser I haven't been using excel for that long and all of the sutton I get a black square box instead of my normal curser and I don't know how to get back to the normal curser. Please help me... 2 01.09.2006 10:00:25 how to convert numeric into words 1) i want 120 to one hundred and twenty only 2) 120.50 to one hundred twenty rupees and fifty paise only these are the 2 quest pls help me... 3 01.09.2006 07:45:13 How to delete duplicate data Hi, I am using excel to consolidate monthly room booking data. I have a date column and time column. May I know how to to delete those rows which contains duplicate data with same date stated in the date columnand and same time range in the time column? Thank you. ... 10 01.09.2006 02:47:01 Need help setting up a way to track Prescriptions I am trying to setup a spread sheet that will allow me to track prescriptions for my mom. She has several drugs that need to be ordered every 90 to 120 days and I don't want to have to manually track them. I would like to enter a start date and a quantity of pills on hand and then have the spread sheet calculate the reorder date for me. The reorder date would have to be about 2 to 3 week... 5 01.09.2006 02:05:01 howto convert a number into words like 10 to ten i want to print numbers entered as numbers in words like 1 is one,20 as twenty also to have two decimal places... 5 31.08.2006 23:43:01 dropdown list to a page in worksheet Hi, I have a list of names in worksheet1 I have a Page for each name in Worksheet2 I need to creat a dropdown list in worksheet2 of names in worksheet1 which will allow me to jump to his specific page. how do i do this? Thanks, Jared... 14 31.08.2006 17:44:16 printing forms Hi, i have this table in one sheet Name Surname Adress Tel.No. E-mail Gender Paul Gaultier Baker st 9995 paul@g.com M John Smith Rose st. 5556 john@smith.com F And in another sheet I have couple of forms (application forms, questionnaires) Applc. form. No.1 Name: Surname: Adress: E-mail: Gender: My wish is, to ha... 7 31.08.2006 16:40:02 Trouble with condition nested formula I am trying to nest two formulas based on the result of another cell: the formula must do one of two functions based result on the lookup cell. A12: is either "A" or "I" B1 $100,000 B2 8% B3 360 formula as written: =IF( a12="a", (pmt(B2/12,B3,B1)*-1,(B1*B2)/12)) the first argument work fine, howver when I enter the second formula (b1*b2)/12, it does not work... CAN ANYONE HEL... 3 31.08.2006 16:26:31 IF with date criteria Hello, This is my problem: Column C has text values (Phone, Meeting) Column F has dates (01/01/2006 - 08/31/2006) but, Column F also has misc text ("*", ".", "?" or can be blank) Column H has text values ("AA", "AA-1", "AA-2", ""BB") I'm trying to find out how many "Phone" calls between 06/01/2006 and 07/31/2006 I'm trying to find out how many "Phone" calls where in the "AA" family ... 5 31.08.2006 12:16:29 View the sheets side by side Hello, I have data spread across two sheets. When I click sheet1 it will occupy the whole window. When I click sheet2, it is the same. I want to see both sheets at one time so that I can see data in sheet1 and side by side the corresponding data for sheet2 thanks, sk1234... 4 31.08.2006 08:27:32 Adding selected numbe in a column I am using Excel to get results of a competition where there are 100 results of which the top 50 count for each player. Need the Total of the column to only add the best 50 scores. ... 6 31.08.2006 03:04:02 how do i prevent continued highlighting cells when cursor moves? Somehow the highlight mode is stuck, no matter where I go, the highlight area can be from 1 cell to multiple of cells up, down, sideways from home cell.... 4 30.08.2006 19:53:23 how do i write a macro to move down in the sheet one line ? I have to enter into a sheet several lines of information but I can't find what the equivalent to the Lotus 123 commands for this in Excel Visual Basic....they would be the down,up, right, and left commands. I thought selection.down would be it but there isn't such a thing. Where do I find a list of commands for vb that would be equivalent to Lotus.... 3 30.08.2006 16:44:02 Repeat Text In cell C2 I have a text entry, Installation Complete XA3C. I need to have repeat every 6 rows, in row 8, 14, 20,etc. Not sure how far down it needs to go, as that will be determined as the process is ongoing. Any way to automate entering this entry for possibly hundreds of rows? Thanks Paul... 5 30.08.2006 16:32:38 How to find cells with non-conditional formatting? Hi, I know how to find cells with **conditional** formatting. Is there a way to find cells that have non-conditional formats? Let me try to be a bit specific. How can I find cells that I have applied custom formats (format>cells>number>custom)? Appreciate feedback. Epinn ... 4 30.08.2006 13:23:26 Controlling Userforms I have designed a userform which produces a combobox(1) - list of items from which an item can be selected. Based on this selection another combobox(2) is produced and displayed on the userform with an item list from which another item can be selected. when an item is selected from this combobox(2) I need to be able to show another userform based on the selected item eg. TYPE1 TYPE2 TY... 2 30.08.2006 11:47:42 adding times again No luck so far ----- Think I just tried that?? And still 00:00 I'm formatting the cells to custom 00:00:00 then in the total box making sure that is the same format. Sigma on the total cell which then seems to want a range of cells put in. Click the top cell and highlight down to the lowest puts the range in. Enter and 0's. :-( ----------------- ... 15 30.08.2006 08:58:40 what is the correct formula to add a column with =sum I want to total columns without typing every cell into the formula. I also need help with if sums. I tried =sum+(d2:d56) and it don't work and neither has any other combination I tried. I would also like to have the balance column in my checkbook automatically subtract the debits and add the credits. Column d is debits or payments and column e is credits or deposits and f is the balance c... 4 30.08.2006 04:00:01 in a column of numb's and names, put the numb's in other colum I have over 2000 lines of a tag # number plus a dog name in one column in excel 2003 which I scanned in. Can anyone tell me if I can edit the numbers into another column automatically??? The entire column in one edit operation??? The tag # into another column. Other than re-typing each line. Thank you in advance for your help, Oswin ... 7 30.08.2006 02:43:07 Adding time HH:MM when it addds up to more than 24 hours Hi, I have a column that adds time which has been formatted to HH:MM in custom format. Just noticed that once the result reaches 24 hours then it restarts at zero. Not exactly what I had in mind! Could anyone suggest a workaround for this please. Whilst I'm here... I wanted to do a data validation for this range to ensure that users enter times as HH:MM but couldn't figure out how to... 9 30.08.2006 02:41:37 Pivot Table Question Hi I run Win2K with Excel 2K I have a pivot table with a number of headings. Whenever I refresh the table the columns always adjust to autofit the headings. I would like to know is there any way that you can fix the column widths on a pivot table so that when you refresh the data they do not go back to the original with. Thanks, any help is much appreciated John... 4 29.08.2006 23:04:55 how to calculate a month without the full date? This might be a stupid question. i have a cell (A1), with a month's name: "April" How do i use a formula so cell B1 will show "May" and when i change A1 to "June" Cell B1 will show "July"? Basically a calulation but without a full date Thanks Jared ... 17 29.08.2006 16:19:21 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  >>