When one has external references in a workbook, a dialogue box pops up on opening the workbook saying... "The workbook you opened contains automatic links...

How to create formula for combining two cells as one cell. All texts as formated as text. Example: 1 2 3 A 123 456 =123456

I'm using Excel 97 and I don't find the tabs on the bottom of a spreadsheet that I opened. Are tabs used on this version of Excel. If there are how can I...

Hi, If I have the following Data, how can Excell help me determine if the change in Today's value in Column C is followed by tomorrow's value in Coulm B....

I used excel workbook to make a calendar -all I added was the month names in the cells on top. I hit file -print- etc. when the copy came out of my Epson...

When using the find feature (ctrl f) with a worksheet that has nothing but formulas contained Find all of a suden wont find the value, it's there because I...

How can I create a formula that will allow me to generate a random 6 digit number? Thanks

I am importing a pile of numbers from Access to Excel. The problem is, Access puts numbers in with the quote mark. If I copy a column then paste special -...

I have an existing workbook that contains a confirmation that gets faxed to customers to sign off approving credit card charges. The credit card # is typed on...

Is there a way I can define a time format within Excel to include milliseconds?

I have a worksheet that shows avg. elapsed time in seconds as a numerical value (ex. 507.84275 is 507 seconds). I need to convert this to a mm:ss format...

Is there a way to take a pivot table and 'unpivot' it back to a normal spreadsheet?

I have recently upgraded excel 97 to 2002 and have noticed that when i formated cells for percentage it multiplies what i put in by 100 to create the...

I set the format for the cell to be a date in the form 11/22 (no year) = and=20 enter 11/15. Excel changes it to 11/15/2003. I do not want the year....

I have a column of numbers including blanks where I want to put into another cell the highest and into another cell the lowest (ignoring the blank or a zero...

IF(AND(DATEDIF(Q14,V$7,"Y")-2,$C14=$C$1),($AA$2*8/24)* ($E14/40) Hi, I am working on a set of dated if statement that I have copied from an old worksheet. ...

Is there a way in Excel I can enter hour/minute values as negative and therefore perform calculations on these figures? I am developing a timesheet which...

How can i automatically color subtotals? Keep in mind that the subtotal rows will constantly be changing. Scott

i am trying to add some code that will close an open workbook without saving the changes to it. thank you for you help.

Hi, I want to display ASP query results in DIFFERENT worksheets, can anybody help me on this Thanks in advance Mahesh