Negative result gives #### is there a way to show the actual - num Terry That doesn't happen because you have a negative number. It's because the column is not wide enough to hold that number. Increase the width of that column. HTH Otto "catts22" wrote in message news:EE982E7F-74EE-403E-965A-389B4708587E(a)microsoft.com... Hi ... 27 May 2010 10:23 Compare between 2 worksheet Hi, Could any one show me how I can compare two worksheet to find out if there are any difference. The 2 worksheet might contain data like Name in column A of worksheet 1 and column D of worksheet 2. Age in column C of worksheet 1 and column E of worksheet 3. Thanks in advance. Terry -- Message post... 26 May 2010 08:04 If greater than 5 Need a formula - I know it's simply - just can't get it. If A1 is greater than 5, then B1 = 5 If A1 is less than 5, B1 should equal the amount in A1 CarolAnn ... 27 May 2010 22:33 Is there a way to "glue" a matrix rectangle of cells together? The cells would only be moved as a group, but could be detached from each other at some point. ... 27 May 2010 17:04 Hour function equivelent help If I want to find out how many minutes there are for times that I have summed, I know I can use the hour function if the compiled time is less than 24 hours. But, what if I want to get the times that are over a 24 hour period, how do I do that? Example: 20:57:46 14:39:10 8:57:24 12:12:12 ------------- 56:... 26 May 2010 09:09 Array formulae do not recalculate I have a large number of array formulae in my sheet. I update the supporting data and the formulae do not recalculate. The only way i can get a recalc is to F2 and then ctrl+shift+enter. How can I get all of the formulae to recalc. Manual recalc does not work. ... 26 May 2010 04:50 linking a sales receipt worksheet to an inventory worksheet I have a sales receipt worksheet that has all my sales items on it. I also have an inventory worksheet. I would like when I make a sale that it automatically is deducted from my inventory worksheet. I have Office 2003 Example: Sales receipt is (sheet 4) In each column Item#-Description-Item Cost-Qty-Cost Exampl... 25 May 2010 16:53 Function to add name of Sheet to a Column? I am preparing to merge sheets in a workbook, before I do I need to find a way to pull the sheet name into ColumnX so once merged I will retain the categorization. Is there a simple formula I can paste/fill-down into a column to do this? Thanks in advance ... 25 May 2010 17:59 RANDBETWEEN generating numbers outside range Using Excel 2003. Simple task of trying to generate a pseudo-random number between 1 and 52 (yes, a deck of cards). I'm populating the cells with =RANDBETWEEN(1,52). Many of the cells are displaying negative numbers. Any ideas? ... 25 May 2010 17:59 returning a text value I think this is simple but I am confused with it. I am creating a softball roster. Column a is the positions, Column b is player for inning 1. C is inning 2 and so on. So with my current grid I can see who is in which position by inning. My second grid will show players name followed by position being played. ... 25 May 2010 15:47