Changing default font in Excel 2003 infodex 0 599
I'm using Excel 2003 on XP Pro. I want to change the default font so that all new text will be in the specified default. I went to Tools > Opti...

Can anyone provide me the fomula ? Utf 1 360
Hi, I need the fomula for below scenario, A4 = start date (exp.= 01.03.2007) B4 = end date (exp. = 31.05.2012) D1 = 01.04.2007 D2= 31.03.20...

Formula Utf 4 411
I'm in need of a formula in C1 that gives me the value of A1 divided into 60 if B1 is empty, however if B1 has a value (not zero) then C1=B1/60. THA...

Excel 2010 Utf 1 512
I have installed Excell 2010 and now when I open the program, it opening all the excels files. It also is trying to open the other files like .doc...

Pivot Table Formulas Utf 0 377
I need to create a variance formula for the data selected in a pivot table. My problem is that the data is coming in from one column and I don't kn...

blank cells having no value Steve 2 434
Hi, though this is Steve's account it is his wife Val writing with my problem. Back in the old days of DOS there was a function which allowed you to...

Help! how to cross - data with excel?? Utf 3 715
Hi, I'm required to present some info at my work, using two excel files. This is the task: File 1, has ID numbers in column A, and column B is bl...

How to determine the value? Utf 2 312
Does anyone have any suggestions on how to determine the value within lists? For example, [1] There is a given date in cell A1, 06-Jun without conc...

Find certain "Text" in a specific coloum, add corres. values Utf 2 250
Hi, I have two coloums. One has text and the other has Values. I need excel to search through a whole coloum, and summerize the results. My coloums...

Converting XLS file to QIF or to OFX Utf 1 680
How do I safely and securely convert an excel file (xls) to a QIF or OFX file? ...