Hi I run Excel 2000 I download information from a mainframe into Excel. In cell F5 the data looks like this: 19.11.2007 This is formatted as text and is...

Using Excel 2003 and 2007. Is there an option for checking spelling as you type (similar to W2003) so incorrect words are underlined? Thanks

Hey there, :confused: I am currently working on a project which required me to do a project using macro. I have to create a macro which enables me to join up...

I frequently work with a lists of text data, some of which consists of digits or digits + alpha characters. These are always formatted as tect fields. When I...

I inherited an excel file. When I open it, I receive a security warning for a macro to enable or disable. I do not want any macros associated with this...

I have a template set up that displays and prints six reports. Each report contains a header showing: Name of Client Account# Title of Report Date Range of...

Hi all, I'm new to Excel, having used MS Works for a customer list/database for many years. I'm trying to decide whether it would be best to have: 1. A...

Hi, Just been told how to use Freeze pane option so my days of the week scroll down the worksheet. My A column has the months in it. I.E I have January in A1...

How do I create a formula that would alow me to select a value in one cell and subtract it from a value I enter in another cell. IE a product with 3...

Hello, I am looking for someone who can assist me with properly designing a simple spreadsheet. Thanks, Shannon

Does anyone why on my form the Cell Shading isn't visible, but when I do print preview it is there. How do I turn on the Cell Shading so its visible when I'm...

class problem; sensitivity reports used by prof show headings final value, reduced cost objective constraint, allowable increase,allowable decrease (etc); mine...

I need to get data from a total cell in one worksheet into a cell in another worksheet. Because the source worksheet will have lines added to it, I wanted to...

To whom it may concern What it is the formula required in Microsoft excel that will return a value of true in cell K1 if the values in cells G1, H1 and I1 are...

I have two monitors. In most applications I can have separate pages displayed on each monitor. Excell will not allow me to do that. Can anyone tell me how...

I have created a drop down menu with 3 options Contact Enquiry Order I want the colour of the text in the row next to the drop down menu to change for each...

Using the SUBSTITUTE function in Excel 2002, can i have more than one substitute in a column ?? I have an excel sheet, e.g. Col A i want to change everytime...

I'm wanting to set a formula so that if cell A1 is "a" then C1 would be 3 and if A1 is "b" then C1 would be 5.