All Forums | Technology

Excel 2007 formatting

Participants:

Posts: 4

BWS77

Legend

Joined: Jan, 2010

Posts: 35351

Posted: Apr. 5, 2014 - 1:20 PM ET #1

I keep a database of games with scores on Excel...

How can I format cells to a show a score without it changing to a date. Example 4-3 changes to 3-Apr

BWS77

Legend

Joined: Jan, 2010

Posts: 35351

Posted: Apr. 7, 2014 - 4:19 PM ET #2

Figured it out... just put a single quote before the first number

'4-3

SportsFan9698

Banned

Joined: May, 2010

Posts: 5575

Posted: Apr. 22, 2014 - 12:44 PM ET #3

Yes the ' always works... but then the characters are "dumb"

I would suggest you enter the scores in two different cells, then it is a number that can be manipulated.

Lippsman

Covers Linesmen

Joined: Feb, 2001

Posts: 87445

Posted: May. 18, 2014 - 9:31 AM ET #4

I used to have a number of spreadsheets that would pull info from websites. But almost everyone of them won't work now with coding most of the sites use now. It was really nice to fire up your sheet and pull all the info you wanted.

All Forums | Technology

Excel 2007 formatting

Hot Forum Topics