Excel question about leading zeros

CrazyKell · 04-13-2009, 10:05 AM

I'm trying to type part numbers into a very simple sheet in excel.

I've figured out how to get leading zeros but what I can't figure out is how to stop excel from adding a leading zero onto every single part number.

The part numbers are varying lengths of both alpha and numeric characters.

I'm not that great at excel so any help would be appreciated!

neebelung · 04-13-2009, 10:06 AM

I believe if you format cells (or at least that column) to "text" it will leave everything exactly as you'v entered it, without auto-formatting anything.

CrazyKell · 04-13-2009, 10:13 AM

THANK you! Much easier solution than formatting all the cells individually. You rock!

neebelung · 04-13-2009, 10:24 AM

Glad I could help!

Cutty72 · 04-14-2009, 01:00 AM

yup.

excel is the greatest program ever.

Particle Man · 04-14-2009, 10:33 AM

Now pivot table the fuck out of it.

Ninjakel · 04-14-2009, 10:34 AM

Quote:

Originally Posted by Particle Man

Now pivot table the fuck out of it.

werd!!!

Rsv1000R · 04-14-2009, 11:00 AM

Quote:

Originally Posted by Ninjakel

werd!!!

No, Excel......

CrazyKell · 04-14-2009, 11:16 AM

Pivot tables are in my future.

Particle Man · 04-14-2009, 01:55 PM

Quote:

Originally Posted by Ninjakel

werd!!!

what's more sad? The fact that we're excited about Pivot Tables or... er... ok, it's just sad

04-13-2009, 10:05 AM	#1
CrazyKell Vrooom Join Date: Nov 2008 Moto: 06 ZX6R Posts: 4,427	Excel question about leading zeros I'm trying to type part numbers into a very simple sheet in excel. I've figured out how to get leading zeros but what I can't figure out is how to stop excel from adding a leading zero onto every single part number. The part numbers are varying lengths of both alpha and numeric characters. I'm not that great at excel so any help would be appreciated!

04-14-2009, 10:33 AM	#6
Particle Man Custom User Title Join Date: Nov 2008 Location: Central NY Moto: 2003 SV650S Posts: 14,959	Now pivot table the fuck out of it. __________________ I'm not "fat." I'm "Enlarged to show texture." Handle every stressful situation like a DOG: If you can't eat it or hump it, pi$$ on it & walk away.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

04-13-2009, 10:06 AM	#2
neebelung Ornery, scandalous & evil Join Date: Feb 2008 Location: Jacksonville, FL Moto: 2004 Scarlet R1 Posts: 5,962	I believe if you format cells (or at least that column) to "text" it will leave everything exactly as you'v entered it, without auto-formatting anything.

04-13-2009, 10:13 AM	#3
CrazyKell Vrooom Join Date: Nov 2008 Moto: 06 ZX6R Posts: 4,427	THANK you! Much easier solution than formatting all the cells individually. You rock!

04-13-2009, 10:24 AM	#4
neebelung Ornery, scandalous & evil Join Date: Feb 2008 Location: Jacksonville, FL Moto: 2004 Scarlet R1 Posts: 5,962	Glad I could help!

04-14-2009, 11:16 AM	#9
CrazyKell Vrooom Join Date: Nov 2008 Moto: 06 ZX6R Posts: 4,427	Pivot tables are in my future.