General

Formula help please
Everytime I enter the number 1 on a spread sheet, can I make it equal a specific dollar amount? For example: 1 = $22.84 If I am thinking correctly then when I add down the column I might have 10 entries and $228.40 ... 4 May 2010 11:13

MSN Stock Quotes add-in for excel
I need a link where I can download this aplication (MSN Money stock quotes add-in for excel), I really needed for my investments record. This link thats the one I found on the micrsoft page http://www.microsoft.com/downloads/details.aspx?FamilyID=485FCCD8-9305-4535-B939-3BF0A740A9B1&displaylang=en Does not Wo... 3 May 2010 18:44

How do I separate first and last names into two columns?
I have received a data base with members' names. Unfortunately the list has the first and last name in one column. I will be adding names and sorting names in alphabetical order. How do I separate the first and last name so that I have two distinct columns -- one for the first name and one for the last name?... 3 May 2010 17:37

Time Values As Numbers
How can I change a time value to a regular number? For example, if I enter start and stop times (Hours-Minutes-Seconds) as 0:02:06 and 0:02:56 (respectively), and subtract the start time from the stop time, I get a displayed value of 17 seconds, which is equal to an actual value of 0.001458333. (By the way, t... 3 May 2010 17:37

Diff in business days
I'm trying to calculate the difference in days between two dates, excluding the weekends. I've tried some of the suggestions on the discussion boards, but usually end up with an error or they're not working for me. Let's assume the dates are in column A and B, with column B being the later date. Please he... 3 May 2010 16:30

Need a shorter # of Levels
I have Excel 2000 so these problems are more than 7 levels is there a way to make them shorter. I did make a vlookup for them but if I have to move the cell then I have to re-reference that vlookup so I figured a formula would be easier if it is possible. Thank you for any help that you can provide. =IF(E4="",0,... 5 May 2010 01:44

protect cell format
how can I keep the cell format the same (protected) when I copy and paste another cell into it? ie. Cell A1 from Sheet 1 is protected with center justified-text along with cell color RED. This sheet is protected and user is not allowed to edit the format. Cell B1 from Sheet 2 is left justifed with no cell co... 3 May 2010 16:30

Pivot Table Data Source
Where in 2007 can I change the data source for a pivot table to look at the first pivot table I created (instead of looking directly at the raw data sheet)? ... 3 May 2010 16:30

Conditional formatting, coloring the whole row
I have a spreadsheet that shows due dates. I have formatted it so that those who are more than a month overdue the date is in red, those who are overdue by less than a month or will be overdue in a month are in yellow. The remaining are in the clear have no color associated with them. My boss would like the ... 3 May 2010 20:57

Deleting rows to resize workspace
Hi. I'm using a workbook that someone else created from a download. It has 23,600 rows -- yet the vertical scroll bar.. when on the last row.. makes it appear that it's only 10% from the top. In the past I've deleted all of the rows - going down to the full million - and then gone back to A1 and hit "save". U... 3 May 2010 16:30