I need to write a formula for the following but am confused as to how to do it. Can someone help? 1. determine gross pay in column F as follows: a. In cell...

Can anyone explain how I could replace all the semi-colon's in a column with the equivalent of an alt+enter so that each value will appear on one line within...

HI, I need to merg colum E with f.. For complete home address. As it stands now. Column E is the street number and Column F is the rest of the street...

When selecting to show formulas in cells, a lot of my columns change their width. I have confirmed that I am viewing the worksheet at the same...

I have subtotaled a spreadsheet and now wish to sort by the subtotals. I have tried collapsing the outline so that I only see the subtotaled amounts and then...

I have a question. I have a column with only the figure 1, but many. Some are hidden (invisible) and some are not. What I want to do is to summurize...

I put in =sum(E1+G23) & the total in the cell where I put the formula comes up(2 or 3) cents off? It comes up short when I put =sum(E1*G23). Not al the time...

I am using Excel 2002 SP3. When I place a jpg into the header and email the document to a customer, they cannot see the jpg when they use print preview. Is...

I have say =sum(E1+G3) E1 = $10.00 G3 = 8 The cell I put this formula in comes up (2 or 3) cents off. This does not happen all the time but off & on.

I'm using the Text to Columns wizard to separate out a comma delimited address field. Works great, but afterwards the data doesn't always match with the...

When I type a nymber, it gets converted to that number divided by 100. For example if I type 100 in the cell, it gets converted to 1.00. How do we set it...

I have one file in local for material puchase requisitions from the site with site requisition number, originator, description ete. And there is one file in...

I'm not totally new to Excel but I only use it to manipulate client data. I need to delete duplicate clients. Not just the duplicate but the original too. ...

I have a sheet which generates numbers using the =rand() function but it has started producing some negative numbers, when they should only produce numbers...

How do I put input boxes and sumbit buttons in excel vba? I am trying to make a address book manually using Excel VBA. Is there a way I can record...

I'm not sure how to ask this, I am currently working on a spreadsheet that has an itemized worksheet depicting each budget approval (Sheet2). I have it tied...

I am using the Nursing Scheduling template for a Dr Emergency room Schedule. I had to change both the department and shift list dropdowns on the data sheet....

We have shared files on a network drive. When a file is open by one user, and a second user opens the file we want them to recieve filename is locked for...

Im trying to enter the numbers 2.9 in cell like AD and it turns it into $2.90. That is not what I need, how do I stop that?

I have found that when I import information into Excel 2003, Hyphens are not converted to a longer type symbol (almost like 2 hypen widths). I've seen it in...