How can I display the contents of a cell in another as part of a text string. Such as... "The answer is "B4"" where B4 is the contents of cell B4? Thanks

Lotus used to have two icons, one that took you to the first cell of the sheet and the second that took you to the last used cell of the sheet. ARe there...

Hi, in Excel 2003 I disable the "Edit directly in cell" option so that when I double-click on a cell that has a formula link ='Sheet1'A23 the cursor goes to...

please farwad me a detail excil table

Ok, I got a three sheet excel file that I cannot get to run calculation on. Sheet 1 has ~4000 rows, 10 columns. Each row has a VLOOKUP and two INDEX...

Hello, I am working on an Excel course from OzGrid. One of the problem/examples defines the MATCH function Array as 1:1. In my ignorance I expected something...

Sir/Mam, I tried this function =CONVERT(2.5, "ft", "sec") but it is not working. it is giving #name? I m using office 2003. yours Rao Ratan Singh

How do I pretect sheets in such a way that users can input data but can't change formulas, macros etc? Thanks John

When i open excel in office 2003 that time it's showing error system error &H8000FFFF(-2147418113).Catastrophic failure If I press ok out of memory If I...

I am working with imported data and I need the information in every 4th cell for a different worksheet. How can I do this.

I have to import a .txt file from a database query into an excel spreadsheet and I can't get the data to format properly. It comes in this format from the...

I am not too understanding of excel to any great extent. But I need to round time to the nearest quarter. Example 8:11 to 8.25 4:41 to 4.75

I Have just activated excel 2003. I am unable to enter data into any cells. I am also unable to enter information into microsoft word. How do I rectify this...

Is there a limit on the number of worksheets that can be contained in a single Excel file?

Hi everyone. Someone on here always has an answer for my question, so thanks in advance. I am running XP Pro SP2, and Office Pro 2003. Column A is for...

hi we have a simple formula to work out employees pay (hourly rate x hours worked = gross amount) however currently exel is not recognising a 6 as a 6 in the...

My full problem is that I have a couple txt files that I need to work with in Excel, however druning the import I can't get a custom format for a column. ...

I have two sets of data (2 worksheets) one set contains a column with 14000 different numbers and a second column with corresponding values to these...

I'm sure there is a simple explanation but I can't come up with it. The following is the formula I am using: =IF(OR(X2="roll not cut",X2="cut not roll"),"OK...

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...