I am using Office 97 Excel Purchase Order template but cannot find out how to have my P.O. numbers to auto sequence. I have been manually assigning them a...

Hi there. In searching for 1024 I found a lot of comments mentioning that Excel has a cell limitation of 1024 characters. What I'm running into is that...

how do I calculate days of every month from a given period (start date and end date)

How do you customize the =Now() so that it is in the format of dd/mm/yy and hh:mm:ss instead of dd/mm/yyyy and hh:mm (military time). I am trying to have an...

Can anyone help me with a rounding issue I have a formula that looks like this F7*F27 16,995*.92134 = 15,658.17 I then need to Round to the nearest 500 and...

What are the rules for creating valid excel sheet names (num of chars, non valid chars etc)

Hello, I am looking for a solution to protect an Excel document to be opened on one computer only. On other computers, the Excel document should show a...

I have a data sheet value as: C:\me2\wa\sourcefile\T30!$F$23 C:\me2\wa\sourcefile\T30!$F$33 C:\me2\wa\sourcefile\T30!$F$43 now I want to get data in same...

I am uploading values from an existing data base. Sometimes there is no items sold during the time so it just gives me a blank area. I need to change that to...

Hi all, I want to count the number of rows (1 to 1000) that have content in columns AK to AO. I want to do it with a formula (so no helper column or VBA). I...

hi! soo.. i would like to know the code for: -in a for loop, for a particular row, finding a cell. ie. if the for loop is on the 2nd row, return the value in...

Please bring back .dbf extension in Excel. This is such an important extension in the work that we do and makes my work life much easier. ...

Hi, I am using Excel 2007. The file I am working on is fine until few hours ago, I re-open the file, all the file format is gone! It looks like the format is...

Looking through various forums, I see that the DATEDIF function can be a bit buggy at times, particularly w/respect to "md" interval type and in Excel...

How do I change the button face to a picture of my own choice once I have put a macro button on the quick access tool bar. I dont want one of the Microsoft...

Hi, I am trying to omit the whole number when it is copied into a new cell. Ex. 29.8765 = .8765 I do not want a leading 0 either or for the decimal to be...

Hi guys, I have a table of about 30 columns. In each row, only one cell of the 30 has text in it. What I would like to do is add a column (say AE) and have a...

I am trying to create a summary table where when the user enters in a criteria, the formula will look up the criteria, the year and name, and return the...

I have the following formula which highlighs the lowest five of ten numbers. =ISNUMBER(MATCH(H10,SMALL($H10:$Z10,COLUMN($A:$E)),0)) All works well until I...

Hi everyone, I have a question about how to extend the use of my vlookup-formula. I have a table with different values like this: C1:4001T,...