S Spear Member Joined Nov 26, 2009 Messages 35 Reaction score 0 Points 0 Nov 27, 2009 #1 Hi guys, I don't know how to fix my problem in Excel. When I am typing a score in a box, for example 3-1, it shows me 3 January... Wtf... How to fix this and show the 3-1? Thanks!
Hi guys, I don't know how to fix my problem in Excel. When I am typing a score in a box, for example 3-1, it shows me 3 January... Wtf... How to fix this and show the 3-1? Thanks!
L LGFIRE Member Joined May 15, 2009 Messages 1,304 Reaction score 0 Points 0 Nov 27, 2009 #2 you could try adding a space like 3 - 1 or some beacuse 3-1 means the 3rd of january but with no year Also if you can post your promblems here it would be nice: http://www.fm-base.co.uk/forum/f55/the-help-thread-t18382.html
you could try adding a space like 3 - 1 or some beacuse 3-1 means the 3rd of january but with no year Also if you can post your promblems here it would be nice: http://www.fm-base.co.uk/forum/f55/the-help-thread-t18382.html
S Spear Member Joined Nov 26, 2009 Messages 35 Reaction score 0 Points 0 Nov 27, 2009 #3 Well, I tried 3 - 1, but the same.
L LGFIRE Member Joined May 15, 2009 Messages 1,304 Reaction score 0 Points 0 Nov 27, 2009 #4 OKay then the only thing possible for you to do is do it like this 3--1 to dashes
R Raikan007 Member Joined Feb 6, 2009 Messages 20,592 Reaction score 7 Points 38 Nov 27, 2009 #5 right click on the cells and format, select the "text" option if you want exactly what and how you type to show within the cells <)
right click on the cells and format, select the "text" option if you want exactly what and how you type to show within the cells <)
D DMF @dmf180593 Joined Aug 7, 2009 Messages 11,407 Reaction score 0 Points 36 Nov 27, 2009 #6 Right click, go to format cells. Select text and then you should be able to type whatever you want.
S Spear Member Joined Nov 26, 2009 Messages 35 Reaction score 0 Points 0 Nov 27, 2009 #7 Thanks guys!
P playin'fm Member Joined Nov 15, 2009 Messages 572 Reaction score 0 Points 16 Nov 27, 2009 #8 We are learning in school how to use this program It sucks
S Spear Member Joined Nov 26, 2009 Messages 35 Reaction score 0 Points 0 Nov 27, 2009 #9 Yeah, we did the same, now we are learning to code in C++ language.
K Kris Member Joined Sep 17, 2005 Messages 10,882 Reaction score 0 Points 36 Nov 27, 2009 #10 Closed.