Missing fill handle When I attempt to expand a column the drag handle is clear, I only get a 4-way arrow and a drawing box. How can I get the black drag handle and eliminate the drawing box from popping up. ... 27 May 2010 17:04 Conditional Formatting In and Across Sheets HI Bob, but then once a name range is defined, how can we apply the conditional format to go down an entire column for example? if: namerange1( ) = namerange2 ( ) then make namerange1 ( ) call yellow background. namerange1 and namerange2 are on two different worksheets. thank you. "Bob Phillips" w... 27 May 2010 17:04 Zero's plotted in charts? Why would I show zero's for a column of data in my chart that are actually very large(56869685). Some of my charts have date segments that are missing when the data is there in the table? I checked the formatting for the data in the table and it is all set to a number, no decimal format. I don't understand? -... 28 May 2010 14:53 Formula for multiple criteria on 2 worksheets I have two worksheets. I would like to have a formula that counts data according to the following conditions. Worksheet 1 A B C 02/15/2009 Keyword Keyword 01/14/2009 Keyword Keyword 01/31/2009 Keyword ... 27 May 2010 17:04 Extract numbers from a string of text Hi, Try this =MID(A1,FIND(CHAR(7),SUBSTITUTE(A1,":",CHAR(7),2))+1,7) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "marcella63" wrote: Need to extract just the numbers at then ... 27 May 2010 17:04 "Do you want to update" msg I have a workbook that asks me this when I open it. I cannot find the link that is pointing to another workbook. Does anyone know an easy way to find this? Thanks so much. ... 27 May 2010 18:11 Convert to negative numbers in whole worksheet I have data imported from another file to Excel with negtive numbers show as 478.56- and so on. Is there a macro to covert all these numbers to a format (478.56)? Thanks Igbert ... 27 May 2010 18:11 Converting a non recognizable date time Thanks for your help! "mlman" wrote: I have high speed monitoring equipment that imports thousands of date time readings as follows: 05/24/2010 14:20:00.000.084 Excel does not recognize it as a date time and I only need: 05/24/2010 14:20:00 Is there a way to convert the unrecognizable da... 27 May 2010 17:04 Conditional Format - How to View??? Is there an easy way to view the conditional format for a cell without going in to 'FORMAT' then 'CONDITIONAL FORMAT' on the tool bar? Someone played with the conditional format for a number of cells on a spreadsheet, and I want to audit each cell of a rather large worksheet. I was hoping there was a way to ... 27 May 2010 18:11 How do I calculate a persons age from birth dates this will do age Put your birthday in cell A1 and test =DATEDIF(A1,TODAY(),"Y") & " Years old " this will do years months and days =DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & " Months, " & DATEDIF(A1,TODAY(),"MD") & " Days" "Rod Bishop" wrote: Wanting a formula to calculate a perso... 27 May 2010 17:04