New Posts For Thread: Excel Help Requiredhttps://community.betfair.com/general_betting/go/thread/view/94082/30206221/excel-help-requiredI have a problem with a spreadsheet covering multiple worksheets. On sheet 1 I have the running totals broken down annually. All previous years are working correctly but 2014 is showing 0.00 even though the cell from sheet 2 is showing 93.52. I havealIt's always good to know that a problem's been solved. I have a whole host of key combinations ready for Ukraine (and other countries) should they step out of line. If you have a political concern just post and i'll give it to 'em.https://community.betfair.com/general_betting/go/thread/view/94082/30206221/excel-help-required?post_id=538218979#538218979alIt's always good to know that a problem's been solved. I have a whole host of key combinations ready for Ukraine (and other countries) should they step out of line. If you have a political concern just post and i'll give it to 'em.Sat, 01 Mar 2014 14:57:39 -0600Thanks for all the replies. I have sorted it now. I closed down Excel and when I reopened it I got an error message regarding the link to sheet 2.Charlie although world order is now restored please keep an eye on the situation in Ukraine as it couldhttps://community.betfair.com/general_betting/go/thread/view/94082/30206221/excel-help-required?post_id=538180103#538180103Thanks for all the replies. I have sorted it now. I closed down Excel and when I reopened it I got an error message regarding the link to sheet 2.Charlie although world order is now restored please keep an eye on the situation in Ukraine as it couldThu, 27 Feb 2014 06:22:05 -0600Sorry al may not have worked for you but I think it helped calm the situation in the Ukraine.You could create a Custom number format, e.g. 00.00, and see if that makes a difference.https://community.betfair.com/general_betting/go/thread/view/94082/30206221/excel-help-required?post_id=538144885#538144885Sorry al may not have worked for you but I think it helped calm the situation in the Ukraine.You could create a Custom number format, e.g. 00.00, and see if that makes a difference.Tue, 25 Feb 2014 00:45:46 -0600World order not restored. I tried what google says and still get 0.00https://community.betfair.com/general_betting/go/thread/view/94082/30206221/excel-help-required?post_id=538141959#538141959World order not restored. I tried what google says and still get 0.00Mon, 24 Feb 2014 16:51:25 -0600Google says:World order is restored and an end to mass panic is obtained by clicking on the offending cell, pressing F2 and then Return. Well most of the time anyway.https://community.betfair.com/general_betting/go/thread/view/94082/30206221/excel-help-required?post_id=538137165#538137165Google says:World order is restored and an end to mass panic is obtained by clicking on the offending cell, pressing F2 and then Return. Well most of the time anyway.Mon, 24 Feb 2014 10:35:04 -0600No Ghetto. It stills shows 0.00 if I get rid of the formula and key in the amounthttps://community.betfair.com/general_betting/go/thread/view/94082/30206221/excel-help-required?post_id=538123719#538123719No Ghetto. It stills shows 0.00 if I get rid of the formula and key in the amountSun, 23 Feb 2014 13:32:18 -0600How is the figure in I50 on sheet 2 being calculated? If you simply stick a number (no formulas just number or text) Does that data display OK on sheet 1 in whatever cell you've put =Sheet2!I50https://community.betfair.com/general_betting/go/thread/view/94082/30206221/excel-help-required?post_id=538121355#538121355How is the figure in I50 on sheet 2 being calculated? If you simply stick a number (no formulas just number or text) Does that data display OK on sheet 1 in whatever cell you've put =Sheet2!I50Sun, 23 Feb 2014 11:52:54 -0600Ghetto Joe The cell is formatted correctly - its number to 2 decimal placesCompound yes that is correct and exactly what I am doing and it is still showing 0.00 on sheeet 1 I50 on sheet 2 is 93.52. I have totals on sheet 1 for 2011,2012,2013 and 2014https://community.betfair.com/general_betting/go/thread/view/94082/30206221/excel-help-required?post_id=538120293#538120293Ghetto Joe The cell is formatted correctly - its number to 2 decimal placesCompound yes that is correct and exactly what I am doing and it is still showing 0.00 on sheeet 1 I50 on sheet 2 is 93.52. I have totals on sheet 1 for 2011,2012,2013 and 2014Sun, 23 Feb 2014 10:54:47 -0600I presume this data for 2014 is the same workbook as the data for 2013 and it is all on sheet2,if it is, on sheet1 in the cell where you require the result type = then select sheet2 and select cellI50 which has the 93.52 in it click enter.Does that fhttps://community.betfair.com/general_betting/go/thread/view/94082/30206221/excel-help-required?post_id=538118157#538118157I presume this data for 2014 is the same workbook as the data for 2013 and it is all on sheet2,if it is, on sheet1 in the cell where you require the result type = then select sheet2 and select cellI50 which has the 93.52 in it click enter.Does that fSun, 23 Feb 2014 08:56:15 -0600I'm still non the wiser where all these cells or formulas are being entered. Have you checked the cell you're sticking the data in to see that it's formatted correctly, just right click on the destination cell and select format cells then make sure ihttps://community.betfair.com/general_betting/go/thread/view/94082/30206221/excel-help-required?post_id=538117717#538117717I'm still non the wiser where all these cells or formulas are being entered. Have you checked the cell you're sticking the data in to see that it's formatted correctly, just right click on the destination cell and select format cells then make sure iSun, 23 Feb 2014 08:35:19 -0600