Is there a way I can format a number so that significant 0's and a letter are conditional? I currently use: ?0"g" ?0"s" ?0"c" - which formats like...

I had posted a question titled "sort numbers" late Friday. And I have still not solved my problem. Would anyone be willing to take a look at the file and see...

Hi, I'm pretty new to writing code, so I wanted to ask for some advice. I've got a code which checks to see if cells in two columns are equal, and if they...

When I choose a spreadsheet to open, I want it to open a new window. This used to happen but now opens in the same instance, just hiding my...

I accidently deleted my volume control on my tool bar and i need it back...is there some way that i could re-download it or get it back?

I am trying to create what I think is a strange spreadsheet and at this point I do not even know if it is possible. I have 3 worksheets that I have named...

I would like to filter a listin Excel to pick out all vehicles sold in the range of $10,000-$20,000 Does anyone know how I can do that? I am in school and...

I have backup files for my Excel toolbars Excel.Xlb and user9.Xlb but what folder do they go in? My toolbars got messed up and a search of the main drive...

I am including a drop-down list in an Excel workbook. When the item is selected from the list it is entered into the workbook at the correct font size i.e. 20...

The formulas is in cells a1:e1. Then cells a2:a6, cell a2=a1, a3=b1, a4=c1 etc... I would like to sort the results in dec. order in cells a2:a6 after each...

Hi I am looking for the best formula to return a value depending on a couple of arguements. I have two columns one with activity , one with a date - say a and...

I was wondering if someone could help me. I was needing a formula that could count how many hours someone has but for it to stop counting at 40. I hope someone...

I am creating a five year cash flow table in excel. Months from Jan 06 to Jan 10 will be along the top and long running construction projects will be listed on...

Hi, I have a cell, say A1, with conditional formatting based on the contents of the cell on the same row, say, 3 columns to the right, specified with...

I'm trying to put together a simple Macro that will help us track the types of calls we get. We have the following categories: Billing Customer Service New...

A Report that I imported into Excel 2003 (for sorting the records) comes in with some of the fields on a second row. How can I sort these records?

I have a named range (A1:A6) which is called MyRange. Lets say each cell is populated with a number A1 = 1, A2 = 2. A3 = 3 etc. In the row (B1:B6) beneath it,...

How do I get data from a row of several groups of merged cells. Even though the cells appear to be one cell, the chart wizard reads every cell in the group...

I have lists of attendees to an annual event. I've taken the lists and combined them, and sorted them by first and last name alpha. I want to keep the names...