Hi , I would like to convert my date which is formatted as mm/dd/yy to a text format but i dont want to change the way the date looks. Currently every time i...

I have a user who has excel worksheets that they use fill colors. These are colors that they use all the time. Suddenly when she opens the sheets, the...

I have imported ROI data for securities to Excel. However, when the ROI comes over, it is formatted as 1.3, instead of 1.3%. When I try to change to format...

Here's my current formula: =SUMIF(A3:A50,"Consumer",J3:J50)/C55 This works fine to get an average sum for everything that reads Consumer, but now I need to...

Hi there Just a quick one pivot tables. Say I have multiple worksheets all with 35k lines or so, all with the same headings and data formats, is it...

In Excel 2003 users were able to consolidate multiple ranges when craeting a pivot table. Is there a way to do this in Excel 2007 ?

All, My question is surrounding creating a calendar in Excel. I'm wondering if there is a way to change the shape of the cells so that I can call attention...

Office 2007 I have inserted the date in the footer. The date format is 04/14/2010. I want to change the format to April 14, 2010. Where can I change the...

Hello everyone, I am using excel 2007 I would like to know how to do the following if possible have column A add column B and put the total in column C and...

i want to do an eblast from a column of email addresses i have in an excel spreadsheet

I have an excel spreadsheet that has drop down boxes and formulas. I want to be able to protect this spreadsheet so that other user will not delete my...

I want to know if there is a way to enter the value of a cell as (for example) 2330 and it display as 23:30?

I have a file that contains duplicate supplier records and I want to be able to identify where a supplier number is duplicated and then delete all but 1 of...

Using XL 2003, is it possible to lock a cell, yet be able to allow a user to make a change to a Validation dropdown list? I cant figure out how to allow...

I am in Excel 2003. The error comes back with a "#value" entry. The original formula was okay until I wanted to add the condition that if there was text...

Hi, I have 2 different reports. One has a list of contracts with a unique id and the other has a much larger list of contracts that also have a unique TEXT...

I have been searching the discussion boards and haven't found the answer to my question. Basically, if B7, B13 B42, B44, etc. have anything entered I would...

I am wanting to disable to 2003 options to where a user can not turn on the row & column headers. Can someone please help with this. Thank you

I would like to combine several spreadsheets and then do a sort of both of them. Is this possible.

I'm trying to write an excel formula to calculate the performance improvement using timestamps. Process A took 2hrs, 20 min, 9 sec expressed as ...