Excel help, easy but important - GoFuckYourself.com

mkx · 10-24-2006, 08:05 PM

I just spent the last hour trying to figure this out but still no luck. I am pasting a bunch of lines from a text file in this format:

99-98
99-97
97
01-94
99-94
93-92

But a few are showing up wrong such as 01-94 shows up at 34335. How can I turn off formating completely and display it in excel in the same format as I write or paste it? This is just the first step of the db I am trying to make and I know when I get to the html part "'s keep appearing randomly. Anyone know how I can just turn this off?

Andre · 10-24-2006, 08:08 PM

Right click in the cell, choose format cell, under number tab select General. That shouls do it.

Peaches · 10-24-2006, 08:12 PM

That's odd. I just tried it every way I could and still get the 34335 even when the other numbers are showing right. Sorry

the Shemp · 10-24-2006, 08:15 PM

Quote:

Originally Posted by Peaches

That's odd. I just tried it every way I could and still get the 34335 even when the other numbers are showing right. Sorry

try changing the cell format to "text"

mkx · 10-24-2006, 08:16 PM

general doesn't change it

mkx · 10-24-2006, 08:17 PM

Quote:

Originally Posted by the Shemp

try changing the cell format to "text"

text just aligns everything to the left

Peaches · 10-24-2006, 08:20 PM

Yeah, for some reason it just doesn't like that number combination

mkx · 10-24-2006, 08:23 PM

Anyway to completely turn off formating? Or is there another program that doesn't do this?

DjSap · 10-24-2006, 08:24 PM

you can add ' in the beginning of the content as '01-94, that prevents the automatic formatting...

the Shemp · 10-24-2006, 08:24 PM

you have to make sure you have a blank cell to start off with.

mkx · 10-24-2006, 08:29 PM

Quote:

Originally Posted by DjSap

you can add ' in the beginning of the content as '01-94, that prevents the automatic formatting...

wooo hoo, thanks, that works, hope it solves the "'s from appearing in the html too, thats the next step though so will know soon

10-24-2006, 08:05 PM	#1
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	Excel help, easy but important I just spent the last hour trying to figure this out but still no luck. I am pasting a bunch of lines from a text file in this format: 99-98 99-97 97 01-94 99-94 93-92 But a few are showing up wrong such as 01-94 shows up at 34335. How can I turn off formating completely and display it in excel in the same format as I write or paste it? This is just the first step of the db I am trying to make and I know when I get to the html part "'s keep appearing randomly. Anyone know how I can just turn this off?

10-24-2006, 08:24 PM	#9
DjSap Confirmed User Join Date: Jul 2002 Posts: 3,869	you can add ' in the beginning of the content as '01-94, that prevents the automatic formatting... __________________ Blog Themes, TGP Design, Writing Services, Grunt Work ICQ: 66871495

10-24-2006, 08:24 PM	#10
the Shemp congrats to the winners Industry Role: Join Date: Nov 2001 Location: Echo Beach Posts: 10,891	you have to make sure you have a blank cell to start off with. __________________ i use Vacares...so should you Submit your picture galleries to my site...Outlaw TGP

10-24-2006, 08:08 PM	#2
Andre Confirmed User Join Date: Oct 2002 Location: Inside Your Head Posts: 1,156	Right click in the cell, choose format cell, under number tab select General. That shouls do it.

10-24-2006, 08:12 PM	#3
Peaches Old broad Join Date: Oct 2002 Location: Away Posts: 13,933	That's odd. I just tried it every way I could and still get the 34335 even when the other numbers are showing right. Sorry

10-24-2006, 08:16 PM	#5
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	general doesn't change it

10-24-2006, 08:20 PM	#7
Peaches Old broad Join Date: Oct 2002 Location: Away Posts: 13,933	Yeah, for some reason it just doesn't like that number combination

10-24-2006, 08:23 PM	#8
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	Anyway to completely turn off formating? Or is there another program that doesn't do this?