General
in [Excel]
|
Saving as Binary Well new to Office 2007 anyway. I posted this question in General Questions on 29th March - no reply as yet. If binary is more efficient speed and space-wise, why isn't it the default format? I'm trying to find out what the downside is before I save a majorly important, large file with heaps of macros in ... 20 May 2010 22:41
How to separate contents of one cell into multiple horizontal cell Trying to separate characters, and numbers from one cell into separate cells. I thought I knew the formual, but can't find it anywhere. Example in cell: 1 better-samual disired result in two adjacent cells: better samual can this be done with a single formula? Thanks for your help. ... 20 May 2010 21:36
Leaving a formula cell blank when data has not yet been added. Hi, I am creating a worksheet that will be completed by a number of people. I have a date formula A B C 1 10/02/2010 =A1+7 (17/02/2010) 2 Blank =A2+7 (07/01/1900) Is there any way to ... 20 May 2010 23:47
Is there an Excel formula to round a date to the end of the month User enters a specific date, I'd like to round that entry to the end of the month ... 20 May 2010 22:41
isnumber search Hi, Can you please help? Trying to look for words in a cell if it contains "FHA" then give me FHA. If it contains "VA" then give me VA. If it contains "Streamline" then give me Streamiline. Anything else give me Conv. I am trying this: =IF(ISNUMBER(SEARCH("FHA",E6)),"FHA") but I can't seem to string the ... 20 May 2010 19:26
external data not in a table I have a worksheet originally created in excel2003 that gets external data from a db2 database. After migrating to excel2007 the external data in the worksheet is not in a table (clicking on a result cell does not make Table Tools appear). When creating a new database query I find that the results always get put... 20 May 2010 17:14
Printing Formatted Cells I have conditional format on a cell to format with say Fill Red ... It displays OK on the screen but doesn't appear when printed? I'm sure it'll be something obvious! ... 20 May 2010 17:14
Header Text I am trying to put Chart Title in header. I open the header, type in text, but text does not appear, not when I am typing and not when I try to display. I am having somewhat similar problem with the entry of data in some cells. though I type in the data, nothing appears. I have overcome this problem by copy... 20 May 2010 18:19
Formula to match Cell with table of contents I currently have a Hyperlink table of contents listing each tab. This is listed in column C. I would like to match a cell (example E400) of each tab with each Table of Contents in column D. This would give me a summary of each tab next to the TOC list. This would help looking up any tab with significant... 20 May 2010 16:08 |