Threads Replies Last Post 125 Pages: <<  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  >>   stop exel from rounding hi we have a simple formula to work out employees pay (hourly rate x hours worked = gross amount) however currently exel is not recognising a 6 as a 6 in the final total eg 520.16 +520.10 should = 1040.26 however it is showing 1040.15 also if .11cents shows it rounds it to 0 and 520.16=520.16 the total shows 1040.11 can someone please help i have not set it up to round up or down... 6 07.07.2006 16:05:07 Reformating a column and getting it to apply My full problem is that I have a couple txt files that I need to work with in Excel, however druning the import I can't get a custom format for a column. Because of this I have to import a column that should always be a 4 digit class code as text, I would then like to reformat it to simply be stored as a custom format of the style "0000". My problem is that once I aply the new format I the... 3 07.07.2006 14:04:03 Matching data. I have two sets of data (2 worksheets) one set contains a column with 14000 different numbers and a second column with corresponding values to these numbers. the second worksheet contains a column of numbers which are some (7000) of the numbers in the first worksheet. I need to put the corresponding values from the first worksheet with the column of numbers in the second worksheet.... 13 07.07.2006 13:16:06 formula works when referring to one cell but not to another I'm sure there is a simple explanation but I can't come up with it. The following is the formula I am using: =IF(OR(X2="roll not cut",X2="cut not roll"),"OK to process", " ") Basically, I am using this with a spreadsheet I receive from another user. I am just trying to automatically mark anything that says 'roll not cut' or 'cut not roll' as 'OK to process' leaving any other comments s... 4 07.07.2006 13:03:01 Using a lookup to return multiple values in one cell?? Ok, basically I want to do a lookup to return some figures... I know all the VLOOKUP, etc... trouble is I don't just want to return one figure. It may be 1 figure but then it may be about 9/10 as well. I've got a list of order numbers and a list of orders that need an invoice date next to them. So I've done a bog standard vlookup and it only returns one figure where as there might be ... 2 07.07.2006 09:28:33 VBA coding needed badly Hey there, :confused: I am currently working on a project which required me to do a project using macro. I have to create a macro which enables me to join up two excel file based on a unique key and paste it on a new sheet.The unique key that is used sometimes only appeared in sheet 1 but not sheet 2 or vice versa but i have to compile all the information together and also i have to choose som... 9 07.07.2006 05:58:59 Network Drives I have a number of Excel files on a network server which it is mapped on my PC as the 'H' drive, however for some users this drive is mapped as their 'K' drive. I have created links to various Access databases for which they auto update when I open the Excel spreadsheets. However when users (who see the drive as 'K') try to open this file, they get an error stating that the file cannot be fou... 3 06.07.2006 21:38:01 Help me "dissect" this function (Excel 2002 [XP]) =DSUM(Membership,Membership!$C$49,C1:C3)+DSUM(Revenue,'Revenue Projects'!$D$2,C1:C3) I'm trying to adapt a budget worksheet from another non-profit for our use. I don't know who the author is and I've had it a couple years, so trying to go that route for help is a non-starter. I don't understand why they have Membership twice; I guess one is for the worksheet and the other is the col... 5 06.07.2006 19:38:42 Applying Protection To Multiple Sheets Is there a quick formula to apply a protection code for multiple sheets without having to protect each sheet one at a time?? Actually this appears to be quite crazy that you can't protect all sheets at once..... Hopefully Excel 2007 will allow this. Thnaks In Advance.. -- Mhz ------------------------------------------------------------------------ Mhz's Profile: http://www.excelforu... 5 06.07.2006 12:22:50 Why Does This Formula Return an Error?? :confused: Hi, what am I doing wrong with the following formula: =countif(sheet1:sheet31!E6:E35,">=1") FOR some reason this formula fails when I use the (sheet1:sheet31) with the column range (E6:E35). Is it possible to include a multiple sheet count and column range in the same Formula? Thanks for any helpful responses.. By the way, the formula works ok just as long as I'm not... 6 06.07.2006 08:01:28 can't change font in work sheet I down loaded a calendar template from M/S but I want to change the numerical dates to an other font. I can change the numbers one at the time but I'm not about to to that to 365 numbers. I tried highlighting a month of numbers and changing the font but it still reverts back to the same font. I am assuming there has to be an easy way?? 2nd question. when I sync this template along with 3... 3 06.07.2006 06:30:37 Dates showing are not what I type I am sorry if this is a stupid question but here goes . If I type in dates as 010106 it gives me 01/09/27 This was raised in an earlier Question I tried the reply by Ragdyer which was (If you were going to enter a *very* large number of dates into a column, where you might consider it worthwhile using several *extra* steps in Text To Columns (TTC), you could enter your dates using *6* dig... 6 06.07.2006 03:19:28 Change data from one cell to another cell How can I automatically change data entered in cell A1 (32454521) into a dollar amount in cell A2 ($16.25)? Thanks for your guidance!... 5 06.07.2006 00:16:29 Retrieve multiple dates, from a week number? I'm really new to excel and this forum, so please bear with me... What I'm looking to do, is having one "week-sheet" and one sheet for every workday, and having each of them updated with their correspondent dates. I.e. when I update/clear the excel file, to start a new week, I would like each of the "day-sheets" to have a cell with their relevant date. Ex I update the file: 1) Cell A... 2 05.07.2006 16:05:02 how can I have a formula result based on multiple criteria/columns I have an expenses sheet set up as follows: A/status B/date C/expense type D/amount 1 allowed 05/07/06 car £20.00 2 notallowed 05/07/06 car £450.00 3 notallowed 05/07/06 car £15.00 4 notallowed 05/07/06 ... 2 05.07.2006 12:45:02 counting duplicates Among Many Sheets, Possible?? :confused: Hi, I have spent countless days trying to find a formula that will allow me to find duplicates across Multiple Sheets within a single workbook. All resources I have checked only allow duplicate finding formulas for A single Sheet. I have multiple sheets 1 to 31 representing a month in which I have a column of phone numbers. i want to be able to know from sheet to sheet (Day to Day... 6 05.07.2006 01:23:01 Linking Tables between sheets I want my Excel file to have 2 sheets with 2 tables. I want the 2nd Sheet’s Table to be LINKED to the 1st (so when I update the 1st, the 2nd auto-updates). Just FYI, I’m planning to hide some rows/columns on the 2nd sheet, but still want it to be linked to & auto-updated from sheet 1’s table. Is this possible in Excel? Bob. ... 3 04.07.2006 14:56:13 How do I change mouse scroll from left and right to up and down? ... 1 04.07.2006 13:59:02 Excel 2007 will not download training practice pages....help! I am studing Excel online but the practice templates will not download; I am following a hyperlink to the page (http://officebeta.iponet.net/en-us/templates/axinstall.aspx?FromArea) but told this link is incorrect ; This program is MS's Office beta program so I expected some problems but not with the training course! Thanks for any help anyone can give me. ... 3 04.07.2006 13:30:50 day/date/year all together can I enter a day into my date & year and then drag to auto fill if so how?... 3 04.07.2006 12:25:01 change margens messure from inches to cm. I live in Ecuador, here we use centimeters for paper sizes and margens. So I need to change the original inches, to cm.... 2 04.07.2006 07:18:19 Creating a Macro Button to Extract Data Hi All, Okay i have an Excel Spreadsheet with 3 Sheets inside this. 1) Summary Sheet: is what i would like ALL the data to go to once i press the Macro Button. I'd like it to Capture all the Data from sheets, 2) Sheet1 & 3) Sheet 2. Please refer to the Attached Zip as this explains it in Depth. Thanks W +-------------------------------------------------------------------+ |Filename: Send... 3 04.07.2006 03:38:17 correct date/days in a template I have found a template in M/S excel download that I would like to use but how do I change the dates. The current template is dated 11/1/2004 -11/14/2004 The template is a biweekly time card which has to be changed every 2 wks and additional days need to be added for when the the starting date starts. This is the link if you care to look at it to help understand what I am trying to ex... 7 03.07.2006 22:50:06 how to auto copy the value of B3 to E5? how to automaticaly copy the value of B3 to E5 while inputing value in B3?... 2 03.07.2006 22:43:30 2 cells inside of one I entered a row into a template sheet. Where there should be 1 cell there is now 2 cells in one of the rows and when I drag down to auto fill, it is not allowing to enter. I get the error message "this operation requires the mergered cells to be identically sized" I have adjusted the hight its the width I can't expand to make it one cell... 3 03.07.2006 22:20:21 125 Pages: <<  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  >>