I see the differece between these formats, but I'm wondering why or when one should be used over the other? Thanks for your ideas.

How do you use the & key in header, the & doesn't appear

Print scaling fails to shrink image enough to print on one page (even though Print Preview shows the data fitting in one quarter of a page). If I try to...

I want to perform an sumproduct type of function with on column of data (1 x n) and the minimum value in each row of a 2 x n matrix. Is there a simple formula...

I have created an interface sheet with a number of control buttons on it. I do not want the buttons to move or change size. I have set the properties...

I am new to excel and would like some advice please. I am treasurer for a forthcoming concert. All the seats are numbered in the concert hall. As the bookings...

One of my files contains a field of Emails. I want to sort it by the ISP, not the beginning of the text. so if an email is , I want to sort it so I...

I'm trying to calculate a trendline using the MACD but I don't know the formula. If someone knows it, I would appreciate it. Thanks.

I'm struggling with changing the date in cell like August 31, 2007 into 31.08.2007, and the range Aug 1, 2007 - Aug 31, 2007 into a european format date. I...

I would like to manipulate dates in an excel worksheet (that is avoiding VBA, I guess i could accomplish my goal with VBA) in a way that would make my...

I am trying to reference the status of a Toggle Button in a formula within a cell. I am trying to have a cell recalculate based upon whether the value of...

Hi. Trying to create a multiple page workbook. Start with 3 pages. Pages 2 and 3 have data that does not change and is used by page 1 with VLOOKUP. I have been...

What's the method for Cell Border in the code module.

Hi Sorry am new to this. Can someone please tell me how I can get the total at the end of a row that text like Mid, Har,Yor, Sto is entered into cells. I...

Hi, I am new in Excel. So, It must be an easy question... I have a date/time a cell with date/time values: A1: 9/3/04 11:13 I need to create column...

Ok, basically I want to do a lookup to return some figures... I know all the VLOOKUP, etc... trouble is I don't just want to return one figure. It may be 1...

why does =GAMMAINV(0,5;389;1) return #NUM! ? This function is supposed to return num only when parametres are less than or equal 0. Excel solves...

I need a formula that will count the TOTAL number of characters in an individual cell - that can then be applied to a range of cells to find all cells that...

I want to find a specific total from a combination of numbers on a spreadsheet. How can i go about this in excel

=INDIRECT("'"&R2C2&"'!R81C3",FALSE) This is the formula I am trying to use. What I am trying to accomplish is to return the value of Cell (R81C3) on...