General

Installation Issues
I cannot open my installed version of Microsoft Small Business Edition 2003, nor Works 8.5 on my XP computer. I get an error message #1305 that says I don't have access to a file. Last Dec., I had a computer guy "fix" my computer and he did all sorts of things to clean it up - I am still running into "surprise... 6 Apr 2010 15:21

Calculating Age NOT as of today but as of a date in the future
http://www.cpearson.com/excel/datedif.aspx -- HTH... Jim Thomlinson "מיכאל (מיקי) אבידן" wrote: One way could be: =IF(A1<A2,DATEDIF(A1,A2,"y"),DATEDIF(A2,A1,"y")) Micky "Deb" wrote: I often need to calculate student age as of a specific date. For example: A1: DOB ... 6 Apr 2010 14:12

Forumla Needed: Text or Number Format
What is the forumla that allows tells you if data is in text or number format. I remember using it before but can't seem to remember it? ... 6 Apr 2010 17:36

How to clear clipboard memory?
Does anyone have any suggestions on how to clear Excel's clipboard memory? If I exit excel, will all clipboard memory be automatically deleted? Thanks in advance for any suggestions Eric ... 6 Apr 2010 14:12

Trust Center - Trusted Locations are greyed out
Microsoft office excel security notices pop up is displayed when I start Excel 2007 to either "enable macros" or "disable macros" I enabled the 3 of them I go to "Excel Options" -- "Trust Center" -- "Trust Center Settings" The "Trusted Locations", "add new location", "remove" and "modify" are greyed out ... 6 Apr 2010 11:56

Insert pdf file into Excel
I tried to insert a 20 page pdf file into Excel, but I only get the first page. Can this be done? Thanks for any help. ... 6 Apr 2010 15:21

Make a csv file open in excel instead of IE
Unfortunately, that article does not show you how to make the fix in Windows 7 and the "advanced" button is no longer there when you're in the screen to change file type associations. I would like to know how to do this in Windows 7 too. "Gary''s Student" wrote: See: http://support.microsoft.com/de... 6 Apr 2010 11:56

Ranking in a Different Way
Basically, I am trying to rank a range of numbers, but when there are two numbers of the same value, I don't want the number that is returned to be their exact rank. Instead, I want ONLY number that have equal value to be .5 less than the value given. So, if I have two number that are equal, instead of being ... 10 Apr 2010 15:43

Trust Center - Trusted Locations are greyed out
Microsoft office excel security notices pop up is displayed when I start Excel 2007 to either "enable macros" or "disable macros" I enabled the 3 of them I go to "Excel Options" -- "Trust Center" -- "Trust Center Settings" The "Trusted Locations", "add new location", "remove" and "modify" are greyed out ... 6 Apr 2010 11:56

random select a percentage from a list
I am trying to randomly select a percentage from a list of 891 for assessment interviews. Do I use Rand ()*.1 for 10 percent of the selection? ... 6 Apr 2010 15:21