General

Excel 2002: Can I not overwriting non blank destination cells ?
Hi, I understand that Copy > Paste Special > Skip Blanks allows copied blanks cells not to overwrite non blank cells in the destination column. How about the other way round ? i.e. to paste only the copied cells (blank or non blank cel)l if the destination cells is blank only i.e not to overwrites any des... 13 Mar 2010 08:39

combine cells
Hi I need to combine the following Columns A and B by using a formula. How can I do it? thanks A B 81 007 88 012 88 014 89 019 result should be 81007 88012 88014 89019 ... 12 Mar 2010 19:34

Your entry cannot be used. An integer or decimal number may be req
I have been trying to format cells and when I do, this message pops up: "Your entry cannot be used. An integer or decimal number may be required." I am also having problems with formulas I already had in place. Anytime I try to change anything in a spread sheet this message pops up. It pops up in a new spre... 12 Mar 2010 18:27

Split the cells
Hi is there any way to split the following cells using a formula, so the last three numbers are separated from the number? e.g. Column A Column B 0C 264 0C 265 0C 267 0C264 0C265 0C267 Thank you ... 12 Mar 2010 18:27

Getpivotdata and greater than or equal to
I'm experimenting with using a pivot table as an intermediate step in a report I'm doing that has been slow. It seems to help speed up the process a bit, I just need help filtering down to the dates I need. Each transaction has a date associated with it, I have gotten the getpivotdata to work except for being a... 13 Mar 2010 10:52

Windows 7 moving desktop icons
there's a lot of chatter about this one, what do you guys think: Excel file (does it with word too) on the desktop, you open it, save it, it moves over to the left side of the screen, like an auto-align, which is not set. Why does it do that? It's the saving that triggers it. If you open and close without s... 12 Mar 2010 17:20

Excel opening cell
Normally, when I select a specific cell and save a worksheet, the worksheet will reopen at that spot. I have one work sheet that first opens at that spot, then immediately jumps to line 621 (no matter which cell was selected at last save). I do have three macros on the workbook, one to automatically format ... 12 Mar 2010 18:27

Hyperlinks
I am trying to use a Vlookup to pull a Hyperlink from a table, into another cell. At this poing I cant seem to get the hyperlink to copy over as well. Is there anyways that I can have this work? ... 12 Mar 2010 16:12

import from files with data in ieee floating point format
Files have ASCII header followed by numbers in IEEE 754 Single-precision format. Can these be imported in Excel? ... 14 Mar 2010 01:15

Need Hyperlink from Menu Page to work in email
I have a workbook with several tabs. First tab is a "menu" type page (summary of other pages). Currently I have hyperlinks to all the other pages from the menu page. What I want to be able to do is copy the menu page into an email and enable the users to click on the existing hyperlinks (whatever adjustments... 12 Mar 2010 13:56