Posted to microsoft.public.excel.worksheet.functions

ichihina

external usenet poster

Posts: 3

REMOVE LEADING ZEROS

00456 Tickford Dr.----456 Tickford Dr.
0785 Fort St.----------785 Fort St.
000309 Old Rock Dr.--309 Old Rock Dr.

How do I remove the leading zeros for these addresses?

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
Remove leading zeros from column	Rich K.	Excel Discussion (Misc queries)	2	January 2nd 07 09:43 PM
How to remove leading zeros using excel 2000	RodJB	Excel Discussion (Misc queries)	7	December 23rd 05 02:28 AM
remove leading zeros from text strings	snooze	Excel Worksheet Functions	2	July 26th 05 05:59 PM
Leading zeros	Paul	Excel Discussion (Misc queries)	4	June 12th 05 04:04 AM
save text field w/ leading zeros in .csv format & not lose zeros?	Ques	Excel Discussion (Misc queries)	1	May 4th 05 06:21 PM

All times are GMT +1. The time now is 04:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us