Threads Replies Last Post 837 Pages: <<  13  14  15  16  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  >>   How do I remove a blank separator from a number (like 2 006) I have the number 2006 in the format "2 006" in cell A1 and I want cell A2 to be in the correct format "2006". How do I accomplish this? Thanks!!... 5 18.09.2006 22:41:44 Link from Excel cell to page in PDF How can I insert a hyperlink from an excel cell to a page in a pdf document? I know how to link an Excel cell to the whole document, but I need to link to a page in the document. -- Mary Using Office 2003 and Windows XP Pro... 1 18.09.2006 22:35:01 use formatting from source cell in CONCATENATE function I created a special format so that leading 0's in a value are printed. However when using the CONCATENATE function of excel, the formatting is ignored and the leading 0's are dropped. It would be valuable (to me) if the formatting of a cell (number of decimal places, leading zeros, etc was "honored" by the CONCATENATE function. ---------------- This post is a suggestion for Microsoft, ... 3 18.09.2006 22:25:02 use formatting from source cell in CONCATENATE function I have created a "specil" format for the display of numbers that shows leading zeros of a value. I then want to use the CONCATENATE function to join multiple cells with this characteristic. Unfortunately the CONCATENATE function ignores the leading zero rule I have imposed on the display of the source cell and returns the result with out the leading zeros if A1= "012345" (as a number with... 2 18.09.2006 22:25:02 Workbook Refreshes For Multiple Users I'm using this to create new workbooks. The workbook gets re-saved every every few seconds. Is it possible to allow another user to have this workbook open and see the changes as they are happening ? I tried the "External Data" but could not get it to work. Sheets(Array("strings")).Select Sheets("strings").Activate ChDir "J:\PROJECTS\Carl\New Folder" Dim sh As Work... 1 18.09.2006 22:24:01 Find and Return Numeric Label based on (Numeric Value) Criterion Hi All, My Numeric Data spans 61 columns and many rows. The Data comprises Numeric Values and Numeric Labels. The Numeric Labels and Numeric Values are in 2 separate consecutive rows of data, a blank row and then a new set of Numeric Labels and Values in 2 separate consecutive rows, a blank row etc. Can you provide a Formula that can return all the relevant Numeric Labels that are paired... 3 18.09.2006 22:20:33 How do I insert alternating blank rows in a list of data? ... 6 18.09.2006 22:09:01 Moving an Excel pivot table to access I have a huge (30MB) pivot table with lots of market data. However, I need to pull this into Access in order to really crunch the data properly. The data looks like this: Region Vendor Product shipped units, etc. Currently the pivot table shows "USA" for the region once, then the Vendor name once, etc. so that when I pull it into Access, all I have is one row with all of the data. ... 3 18.09.2006 21:27:19 Update PivotTable I have a series of pivottables on different tabs. I have the first one updated from an MS access database. The rest of the pivottables are all built on the data from the first pivot table. I have a macro set up to do the requery to the database which works fine - however, when I try to get code to refresh the rest of the pivotTables, which are built on the dataset from the first, i am ru... 5 18.09.2006 21:23:07 Can autofilter sum and average columns of numbers? Thank you When using autofilter is it possible to sum or average columns of numbers? When I filter a data base the column return includes all the filtered out numbers. If not is there an add on I can use? Thank you for any help you can provide.... 3 18.09.2006 21:05:28 Transfering a formula from one worksheet to another How do you Copy a formula from one workbook to another. I make updates to a daily changing workbook, so when I have the updates ready i need to transfer them form one workbook to the original. When I do, the formulas reference the workbook that I update, not the original. How do i do this and keep the formulas exactly as they are? Todd... 3 18.09.2006 20:59:29 Excel worksheet formatting Can anyone explain why my Excel worksheet has formatted to show each cell as it's own page?... 1 18.09.2006 20:59:02 Find contents of the last cell in a row I'm trying to create a fn that will give me the contents of the last cell in specific rows. The column of that cell differs by row, unfortunately, and occasionally the content is '0', which I would need to have as a result of the formula. Any assistance would be greatly appreciated. Thanks.... 5 18.09.2006 20:37:56 how do i translate a full powerpoint presentation in one go? I have a ppt in Italian that i need to translate in English. Office help tells me to choose "Translate entire document" under Translation option in the Research pane but i am not able to find this option at all. The only option i seem to have under tanslation is "Translate words or sentences". I am on Office professional edition 2003. Can somebody help me with this? I would appreciate it... 3 18.09.2006 20:31:43 Split non delimited data into multiple cells How do I split a single cell of data into multiple cells, when it is a continous text string without delimiter characters? I want each single charcter of the string in its own cell. I am importing an ascii file and can separate the data manually during importi, using the fixed width, delimiter function, but it makes me manually place the seperator bar between each character. I could h... 4 18.09.2006 20:12:02 multiple criteria formula I am trying to create muliple formulas for one column. Column C - I have client Age Column G - This is going to be any value, however if the client is younger than 50 years of age, the max value is $15,000. If the client is above the age of 50, the max value is $20,000. Also, in column H, I need the max to be 4% of Column D divided by twelve (monthly income) Thank you Thank y... 2 18.09.2006 20:08:02 User Form: Consecutive numbering We are currently using a manual shipping form each time we want to ship something and the shipping department manually processes it and returns a carbon copy of the form. We'd like to automate that in Excel (not sure if Outlook would be better) but need to be able to assign a consecutive number that can be referenced by the shipping department. This would mean that each time, a user acce... 2 18.09.2006 20:07:21 Time conversions I am trying to convert some times in my spreadsheet. I know how to convert mins. to hrs but the problem I am having is this for example: I need 39.20 to show as 39.33. Does any one know the formula or how I can do this?????????... 4 18.09.2006 20:06:01 Help with sorting Help. I am new to this. I have a worksheet that somehow I hit create a list ( I think) and it hightlights that column with a blank cell and a blue astrick. When I try to sort my data now the sort button is not highlighted and I can not sort. Thanks Jody... 4 18.09.2006 20:03:24 NETWORKDAYS not working Hi All, I dont know why the NETWORKDAYS function gives me a NAME error. Please help gary ... 2 18.09.2006 19:56:24 Tricky Formula Hello, I am not sure if this can be done or not, but I am looking to find a formula or something to sum values of a list, but only sum if there is more than one product. Here is the example: I want to add 60971, 60975, 60982 dollar amounts to get a grand total, but I don't want to include 61097 or 60972 or 09710 because there is only 1 item each. I tried to use a pivot table but got ... 5 18.09.2006 19:53:01 IF Function (.......... How can I write an IF formula where I can type a NUMERIC value in one cell and the adjacent cell automatically types TEXT selected from another Excel Workbook? Example: While in Workbook (Estimates.xls) in cell C22, I want to type an IF formula --> IF(B22=20,C22=text from another cell in another Workbook). The other workbook is 'Prices.xls'... 3 18.09.2006 19:48:02 Text formatting I am working off someone else's spreadsheet and the text is different throughout. How do I make all the text lowercase/uppercase, without having to manually do it? -- Kace... 2 18.09.2006 19:28:02 jump to 1st blank cell i have a spreadsheet with over 800 rows. i input info from a to i and from j to v i have formulas. i need someway (by clicking a button) of going to the first blank cell in column a. can someone please help with this. and i would like to back to row number 7 by clicking a button. thanks and GOD bless, mark -- mark lane... 1 18.09.2006 18:58:43 Incorporate Laurent Longre's morefunc with Excel xcell05.free.fr/ This is such a widely used add-in in the Excel community, why not just incorporate its formulas to future versions of Excel? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the sugg... 1 18.09.2006 18:56:02 837 Pages: <<  13  14  15  16  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  >>