Jump to content

Spreadsheets


Recommended Posts

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


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

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

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

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

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

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

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. :tongue:

 

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

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

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.