General

totalling a group of worksheets
I want to create a summary worksheet which will total, say, worksheets between a sheet called 'start' and a sheet called 'end' without typing the individual sheet names, so that I can then insert sheets between those called start and end without redoing the formula in my summary sheet. something like =sum(st... 7 Feb 2010 00:00

excel 2003, list box:
i size it the whenever i reopen the worksheet the size changes. i can size it using both with the handles and with the properties box ... 6 Feb 2010 19:39

How add a digit to front of number in each cell in excexl column
I have a worksheet containing a column of cells each containing a mobile phone number - the number in the cell is 7 digit , but needs to be 8 digit (commencing with a "0" - which is now missing ) I need to insert a 0 at the front of current string of 7 digits in each cell - I've done this before but have for... 6 Feb 2010 19:39

Rounding up/down to .95
This is a Mircosoft Office 2007 Excel spread sheet. I need to figure out a formula that can round up or down to $xx.95 using the following situation cost: 18.23 mark up: 1.8 Retail-based on this alone would be $32.81 A1= Cost A3= Retail A2= Mark up Formula used in A3 is- =A1*A2 My problem is that ... 6 Feb 2010 22:55

How do I link cells between to sheets in MS Excel?
I have an Excel workbook pulled up with 3 different sheets. I need to link cells between one sheet to the next. How do I do that? ... 6 Feb 2010 16:20

Replacing a formula with the actual string or number
I have separated a long list of addresses where the street number and street name are all in one cell. Using FIND, LEFT/RIGHT, and REPLACE, I have now two columns, the first with the street number and the second with the street name. But I cannot sort because when I click on a cell, the formula is there, not the... 6 Feb 2010 02:08

Excel - Negative nested if then conditions
Help, my formulas does not seem to calculate negative numbers. If a= 91 then result is 30 days. =if(a<-90,"-90days",if(a<-60,"-60days","30 days")) -- TTB Thanks! ... 6 Feb 2010 06:24

If statement to go through every worksheet
OK I started a question earlier about this and I got it answered BUT now I would like to modify it further. Here it is: =IF(C2=1,SUM(First:Last!A1),"") What I need this function to do is for each worksheet check if cell C1 has 1 in it and if if does include it in the sum. This function right now only che... 5 Feb 2010 22:53

Excel 2007 display and print are different for different users
I have 2 users that open the same spreadsheet. The spreadsheet shading looks quite different on both displays and prinnts the different shading. They are both using the same 2007 version of Excel and printing to the same printer ... 5 Feb 2010 17:20

Consolidate
I have a list of over 2400 names in column A as firstnamelastname They need to be turned into email addresses w/ the same domain name. How do I do this? Basically I need to turn into firstnamelastname(a)domainname.com Thanks in Advance ... 8 Feb 2010 16:51