How to add leading 0 to four digit number?

Calendar Control

Posts: n/a

How to add leading 0 to four digit number?

I have a column of Zip codes in an Excel spreadsheet. Some of the values are
4 digits in length and some are 5 digits in length. I need to have the
column in text format, but since the format was numeric the leading zero
disappears. I need a formula that determines that if the length of the value
is 4 characters than add a leading zero.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Seed numbers for random number generation, uniform distribution	darebo	Excel Discussion (Misc queries)	3	April 21st 23 09:02 PM
How to format a number in Indian style in Excel?	Victor_alb	Excel Discussion (Misc queries)	2	December 21st 04 04:21 AM
When we enter a 16 digit number (credit card) the last digit chan.	ceking	Excel Discussion (Misc queries)	5	December 8th 04 11:45 PM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM
single quote 10-digit number that has leading zeroes & then conca.	lorelei739	Excel Worksheet Functions	1	November 5th 04 12:02 AM

All times are GMT +1. The time now is 10:31 AM.

Menu

About Us