excell 2007

horsemen_ · Post by **horsemen_** » Sat Sep 08, 2007 9:03 pm

i made a football spread sheet but when i put in the w/l as 1-1 or 01-01 it makes it jan 1 how do i make it stop converting numbers to dates ?

Easto · Post by **Easto** » Sun Sep 09, 2007 11:48 am

Format the cell as text

horsemen_ · Post by **horsemen_** » Sun Sep 09, 2007 6:24 pm

when i click on text it has other options then what because nothing wants to leave the 1-1 2-1 alone it always chaging it to somehting

Redduck · Post by **Redduck** » Mon Sep 10, 2007 8:44 am

If you put something like 2-1 or 1-2 in excel it will treat it as an equation, giving you back the result. If you want to simply put 1-2 in a cell, you will need to precede it with a single quote mark ('). So, your cell would be typed in like this:
'1-2

Hope this helps.
Ken

horsemen_ · Post by **horsemen_** » Mon Sep 10, 2007 7:23 pm

ya thats what i doing now just seems there should be a way around that

Redduck · Post by **Redduck** » Mon Sep 10, 2007 8:28 pm

Those are the only two ways I know, either preceding with the ' or formatting the cell as strictly text. You could always format the whole row, column, or even the whole sheet as text and you will not have to use the '...

Ken

axdhakal1 · Post by **axdhakal1** » Mon Sep 10, 2007 8:31 pm

so cant we simply put 1-2 as horseman says.
why cant this excel input these formatted datas / like 1-2? Bill sucks mann.

Redduck · Post by **Redduck** » Mon Sep 10, 2007 11:32 pm

If all you want to do is enter text into a table, create a table in Word and work with it there. The reason Excel makes you jump through hoops is that it is primarily a spreadsheet, developed to work with numbers in terms of equations, not just for formatting.

Ken

loop2kil · Post by **loop2kil** » Wed Sep 12, 2007 12:29 am

In all honestly what Easto said will work...or at least it did for me.
format the cell to 'text', then whatever you type is what will appear. the '=' sign needs to be used first for it to be considered an equation.

example: 2-1 showed up as 2-1

loop2kil · Post by **loop2kil** » Wed Sep 12, 2007 12:30 am

if you already have something in the cell and then try to format it to 'text' it will change to something weird, so make sure to format all the cells before you start typing.