Posted to microsoft.public.excel.misc

external usenet poster

Posts: 125

Postal codes

Most postal codes have 5 figures. When importing files from certain external
program becomes e.g. 05235 -- 5235 (without the 0 in the beginning). How to
insert 0 in front of the 5235. I have 10000 rowes and don't want to do it
manually....

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
international postal codes	JJ Johnson	Excel Worksheet Functions	3	November 10th 07 03:23 PM
formula for Canadian postal codes	LB	Excel Worksheet Functions	7	July 18th 07 12:07 AM
formula for Canadian Postal Codes	LB	Excel Worksheet Functions	6	January 25th 07 06:30 PM
UK Postal codes in Excel	Paul G	Excel Worksheet Functions	6	October 30th 06 12:07 PM
Distances between Postal Codes	Irfan	Excel Discussion (Misc queries)	1	May 31st 06 10:49 PM

All times are GMT +1. The time now is 11:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us