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!

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!

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