I need to fill cells 15 charecters in length with zeroes, the cells have numbers in them already, ex. 45678 needs to read 000000000045678. The numers in the...

I can see the result in the VLOOKUP Wizard box, but when I click OK I get the formula in the cell, not the result. Can anyone help/ Thanks. -- Marilyn...

How do I locate merged cells in my Excel worksheet? I am receiving an error messages when I try to sort the worksheet which tells me to either unmerge all...

I have a Master Tab Showing (the table has 1000 records) BU_CD CY_CD Cntry_CD Att_1 Att_2 Att_3 ...

I have the following Data A B C D 1 X1 10 X2 2 2 X1 15 X3 5 3 X2 5 4 X2 6 5 X3 11 6 X3 ...

I made a macro on the excel and at the end of the macro I save it on a new file. Can I put the date when I save the file as part of the file name? Here is...

I have a spreadsheet where text in column of cells started repeating in each cell. No formulas are entered in any of the cells. For example cell B3 shows...

I am creating a dummy site for college but have run into a few problems, Firstly i am trying to publish the site with frontpage 2003, I am hosting it with a...

when i filter data, the number of responses no longer appears in the bottom left corner of the screen. how do i know how many items meet my filter criteria?

hey all, i have some data like so: ga, aug, rep1, $10.00 ga, atl, rep2, $5.00 ga, aug, rep1, $7.50 ga, aug, rep3, $5.00 is there a way in excel to convert...

how I can convert in excel this code 775165843020 in a barcode UPC12, I just found UPC6, how I can get it?

Hello, So I have a table with some Lines and some Columns. I am filling this Lines and Columns with the help of a form that is opening when I am pressing a...

I am trying to save time counting the days newly-hired teachers will work in a 180-day work year. I have a spread sheet(school calendar) with all the...

Hi I use Excel 2007. I have a pivot table set up with a Report Filter showing all the months of the year. Is it possible if I select the items from the...

I am using "CellhasFormula=GET.CELL(48,INDIRECT("rc",FALSE))" to conditionally format/colour the cells those have formula. Most of the formulas are like ...

Dear John Many thanks for your advice, you nailed it. Although I did have to work hard to impress upon XL my interest in getting a result. I had to use the...

Hi everybody, I have a question. We have since last year MOSS 2007 as Portal for our factory. Many guys are still working with Excel 2007 and have done some ...

I have a vba code that opens a file placed on my desktop, but this vba code must be used in several pc's, and in every pc the desktop path is different due...

I posed my problem earlier and Dave Peterson gave me the solution. However what I said I needed was incorrect. I have only shown 11 rows of what is...

I want cell 'G4' to show "Red" if the value Cell 'D4' is greater than the value of 'A7' and 'E4' is greater than 'A9' and show "Green" if any one of them is...