Format Numbers with preceding zeros

jgoulart · May 17th, 2002, 03:54 PM

I am trying to parse a text file that has a date field for the expiration of a cc. My dilemna is that I don't know how to take a number say for instance 01 and preserve it's leading zero. How can I format a number that insures that is xx # of digits even if it has to put zeros leading. Thanks for all of your help.

John

Nimrod · May 17th, 2002, 04:00 PM

Goto :
-format
--custom
--- type = 00

sen_edp · May 17th, 2002, 04:02 PM

hello

try format ->custom ->00 for 2 digits or 000
for 3 digits

i.e. if you have number 4 it will show 04

or if you have number 15 it will show 015

Tommy Bak · May 17th, 2002, 04:18 PM

When you do the parsing, set the field as a textfield.
This way you will keep all leading zero's.
regards Tommy

Mark W. · May 17th, 2002, 04:24 PM

When you do the parsing format the column as a date... and forget about leading zeroes!

Tommy Bak · May 17th, 2002, 04:46 PM

Yes, Mark W
You're right.
I read Date as Data
regards tommy

May 17th, 2002, 04:00 PM	#2
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Goto : -format --custom --- type = 00 __________________ <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

May 17th, 2002, 04:02 PM	#3
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	hello try format ->custom ->00 for 2 digits or 000 for 3 digits i.e. if you have number 4 it will show 04 or if you have number 15 it will show 015 __________________ Best Regards Andreas

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

May 17th, 2002, 03:54 PM	#1
jgoulart Board Regular Join Date: Feb 2002 Location: John G Posts: 62	I am trying to parse a text file that has a date field for the expiration of a cc. My dilemna is that I don't know how to take a number say for instance 01 and preserve it's leading zero. How can I format a number that insures that is xx # of digits even if it has to put zeros leading. Thanks for all of your help. John

May 17th, 2002, 04:18 PM	#4
Tommy Bak Board Regular Join Date: Feb 2002 Location: Guderup, Denmark Posts: 287	When you do the parsing, set the field as a textfield. This way you will keep all leading zero's. regards Tommy

May 17th, 2002, 04:24 PM	#5
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	When you do the parsing format the column as a date... and forget about leading zeroes!

May 17th, 2002, 04:46 PM	#6
Tommy Bak Board Regular Join Date: Feb 2002 Location: Guderup, Denmark Posts: 287	Yes, Mark W You're right. I read Date as Data regards tommy