General

Breaking Links - BUT WHERE ARE THEY???
Dammit Microsoft! I'm trying Office 2007 and in Excel's Edit/Links routine, although you have at least added a "break links" option, you STILL haven't incorporated a means to discover which cells/formulae contain the links. SURELY you would instinctively know the importance of finding such cells to be able to k... 31 Mar 2010 09:52

please suggest a formula
i have 2 dates i.e, eg: Issue Dt & Expiry Dt. Amount 06.01.10 31.12.10 10000000/- now i would like to calculate the commission for every quarter from the issue dt. till expiry dt.i.e, from 06.01.10 next chargeable commission is in the month of April like that i have to calculate till the expiry dt. ... 31 Mar 2010 07:39

Custom Footer
I am using Excel 2002 and have eneterd a custom footer. I would like the footer note to appear on four of five pages. In affect I want to leave the footer of the last page (page 5) when printing all the pages. Not sure Excel can do this? -- James ... 31 Mar 2010 08:45

calculation msg box
Hi All I need a macro to pop up a msg box to indicate that the sheet is calculating and how far along it is, any ideas? Thanks ... 31 Mar 2010 08:45

My CD won't let me save my Excel workbook on them?
I have created Excel workbooks but when they are saved under excel workbook and I put in or have already have in a CD for saving on, My Excel says that my computer can not format this kind of disc. I have had these discs before and have saved on them many times. I recently bought CD-RW so that I could erase a... 31 Mar 2010 03:18

Sorry for the double posts here
Thought I'd lost the previous post.... ... 30 Mar 2010 22:59

Display the date in an unusual format
I'm using Excel 2003 Sp3 I'd like to display the date entered in cell H3 in cell I3 in the following format: 20100331215045 2010 year 03 month 31 day 2150 hour and minute 45 the seconds I'm sure there's a formula there somewhere......LOL Thanks in advance, Barry ... 31 Mar 2010 00:04

How to display a date
I would like to display a date time in the format of: 20100331213045 etc.. the 2010 being the year the 03 being the month the 31 being the day 213045 being the time hours minutes and seconds in military format. this would look to cell H3 for the date time entry to display I'm sure there's a formula there... 31 Mar 2010 02:14

Adding current dates to adjacent cells automatically.
I'm creating a checklist in Excel 2007 and would like to know how to add a date in an adjacent cell automatically whenever I enter a specific # into another cell. Does any one know of a simple formula? Would apreciate it very much. FS. ... 31 Mar 2010 12:08

i am trying to say =if a2 is greater than 2000 add 250
i am a new excell user 2007 how do i get the formula to say if A@ is greater than 2000 add 250 ... 13 Apr 2010 06:12