Bleep1673 Posted December 2, 2016 Share Posted December 2, 2016 Over the last two years I have done a spreadsheet for the division Swinton has been in, just as a hobby. However I have found that if I put a score, such as 12-16, it changes the box to Dec-16, every time I put a score less than 13 in the box it changes it yo a date, and I have to put a comma, instead. Does anyone know how to get around this? I am on Windows 10 Link to comment Share on other sites More sharing options...
ckn Posted December 2, 2016 Share Posted December 2, 2016 Over the last two years I have done a spreadsheet for the division Swinton has been in, just as a hobby. However I have found that if I put a score, such as 12-16, it changes the box to Dec-16, every time I put a score less than 13 in the box it changes it yo a date, and I have to put a comma, instead. Does anyone know how to get around this? I am on Windows 10 If it's just one column you need to have right, select the entire column, right click then Format Cells to Text. That way, what you type is what you get. (obviously, if it's a row then select a row, if it's the entire sheet then select the entire sheet.) "When in deadly danger, when beset by doubt; run in little circles, wave your arms and shout" Link to comment Share on other sites More sharing options...
Griff9of13 Posted December 2, 2016 Share Posted December 2, 2016 Click on the column header so all the cells are selected. Go to "format cell" and choose text. Excel tries to guess what data type you are inputting into a cell and sees separators such as - or / as part of a date. "it is a well known fact that those people who most want to rule people are, ipso facto, those least suited to do it." Link to comment Share on other sites More sharing options...
Griff9of13 Posted December 2, 2016 Share Posted December 2, 2016 Snap! "it is a well known fact that those people who most want to rule people are, ipso facto, those least suited to do it." Link to comment Share on other sites More sharing options...
tonyXIII Posted December 2, 2016 Share Posted December 2, 2016 If you want to do any maths on the scores, you may have a problem with a text formatted cell type. You may be able to extract the individual scores by using some of the text manipulation formulas or it might be easier to have two cells (columns?), one for the FOR score and one for the AGAINST score. Just a thought, in case you want to sum the scores and calculate points differences or points-per-game averages. edit: removed the 'e' from 'one' to leave 'on', which is what I intended. Rethymno Rugby League Appreciation Society Founder (and, so far, only) member. Link to comment Share on other sites More sharing options...
Spidey Posted December 2, 2016 Share Posted December 2, 2016 To save changing cell settings just put a ' before the score. It says to the cell all the content is text and will ignore any autoformats or formula Link to comment Share on other sites More sharing options...
Griff9of13 Posted December 2, 2016 Share Posted December 2, 2016 If you want to do any maths one the scores, you may have a problem with a text formatted cell type. You may be able to extract the individual scores by using some of the text manipulation formulas or it might be easier to have two cells (columns?), one for the FOR score and one for the AGAINST score. Just a thought, in case you want to sum the scores and calculate points differences or points-per-game averages. "it is a well known fact that those people who most want to rule people are, ipso facto, those least suited to do it." Link to comment Share on other sites More sharing options...
Padge Posted December 2, 2016 Share Posted December 2, 2016 Use a database, Access is more than adequate and gives you far more options of what to do with the data. Visit my photography site www.padge.smugmug.com Radio 5 Live: Saturday 14 April 2007 Dave Whelan "In Wigan rugby will always be king" This country's wealth was created by men in overalls, it was destroyed by men in suits. Link to comment Share on other sites More sharing options...
Dave T Posted December 3, 2016 Share Posted December 3, 2016 Alternatively split the scores over two cells rather than one as it will allow you to use the numbers Link to comment Share on other sites More sharing options...
Farmduck Posted December 3, 2016 Share Posted December 3, 2016 Did you try switching it off then switching it back on again? Link to comment Share on other sites More sharing options...
Bleep1673 Posted December 3, 2016 Author Share Posted December 3, 2016 Alternatively split the scores over two cells rather than one as it will allow you to use the numbers It would be too cumbersome Link to comment Share on other sites More sharing options...
Bleep1673 Posted December 3, 2016 Author Share Posted December 3, 2016 one for the FOR score and one for the AGAINST score. Just a thought, in case you want to sum the scores and calculate points differences or points-per-game averages. I do it basically to keep my mind sharp, I run a table as well, and do points diff, and know how to do maths on excel, as I also used excel for my invoices/accounts when I was a self-employed teacher of BLS/ILS Link to comment Share on other sites More sharing options...
Bleep1673 Posted December 3, 2016 Author Share Posted December 3, 2016 Tried copying/pasting the entire thing on here, it didn't work Link to comment Share on other sites More sharing options...
tonyXIII Posted December 3, 2016 Share Posted December 3, 2016 I do it basically to keep my mind sharp, I run a table as well, and do points diff, and know how to do maths on excel, as I also used excel for my invoices/accounts when I was a self-employed teacher of BLS/ILS Sorry if I was teaching grandma to suck eggs. Sometimes, though, grandma needs to be told. Good luck with whatever you are trying to achieve. Rethymno Rugby League Appreciation Society Founder (and, so far, only) member. Link to comment Share on other sites More sharing options...
Shadow Posted December 3, 2016 Share Posted December 3, 2016 Use a database, Access is more than adequate and gives you far more options of what to do with the data. Without wishing to sound patronising ........... If Bleep needs assistance formatting a cell to be basic text then suggesting he use an Access database may be a bit beyond his comfort zone. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.