I need to add a trailing comma to a number. I have a column with a few thousands rows in it, and I need to add a comma to each number. I need to use this...

I am trying to use the insert function in developing a VBA application for Excel and I noticed the second parameter to the Insert function in the new Office...

Hi It seems you have some formulas in cells C84, E84 and G84, which sometimes return #DIV/0 Use in those formulas error checking,...

I have no knowledge of formulas or functions. I have 2 cells with one number in each. In the 3rd cell I would like to choose the greater of the first 2...

Thanks Kevin. I'm going to email the file to you. It's a tough one..... Lynn -----Original Message----- Hi Lynn, You have to do a bit of detective...

Alex, =INT(A1/10)+1 More generally, =INT(A1/NumOfLevels)+1 HTH, Bernie

is it possible to use the index match method with multiple sheets? And how might it be done? I've tried a couple of different things. My Data is quite...

I hope someone can help. I set up a spreadsheet. Each column has a different basic formula. eg column A and 1st line has an amount the column B has a...

If I understand your question you can go to Data / Text To Columns in Excel and it will do it for you. It offers you different choices on which delimeter to...

i'm having a problem with vlookup not accepting a "reference" to a cell as the "lookup_value" this =VLOOKUP(C2,range,2) returns #N/A but if i manually type...

I hope someone can help. I set up a spreadsheet. Each column has a different basic formula. eg column A and 1st line has an amount the column B has a...

Due to the way someone 3 stops down the chain from me is exporting, the autocalculate function does not work with my data. For some reason, if I go in and...

One of the formulas in excel help =COUNT(A2:A8,2) that is to count the number of cells that contain numbers in the list A2:A8, and the value 2 dosen't work. ...

What I want is have a today function eg in cell A1. based upon entering any text in for eg b2, puts me the julian dat in cell A2, So far, so good, I got that...

I'm going crazy. I'm trying to add up a column of time. Employee enters time in and out for a two week period. The total number of hours appear in column I...

hi there... in one column i have a "date added" field - it is is month/year format in a second column (entitled "date eligible for removal) - i want to have...

I have a schedule with 10 digit numbers in each cell (about 2,000 rows). I need to apply a different formula to each digit in the cell. Is there a way to get...

OK here is what I'm trying to do. I want to have an entry line where I could put things like Date/Name/Description, then hit a button and have that...

Hi, I have a three command buttons, one links to a particular cell on a worksheet and the other two open up a browser window. The VB for these buttons...

Assuming your price is in A1 and the prices you wish to compare are in row 3: 1. Select row 3. 2. Format Conditional Formatting 3. Select "Formula Is" in...