Posted to microsoft.public.excel.misc

external usenet poster

Posts: 270

Probably a Stupid Question

I have data formatted as text, with leading zeroes, such as 00AF234, 014F,
etc. Is there a way to remove these leading zeroes (other than VB)? The
data could be of any length and have 0, 1, 2 or more leading zeroes. Can't
do find/replace because other zeroes (like in the middle of the data) would
also be removed. Nothing I've tried seems to work, short of sorting by
length, then doing =right. Any ideas please?

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
stupid question	Kimberly	New Users to Excel	4	May 18th 07 08:55 PM
Stupid If statement question....	Send Object Command - Two attachments	Excel Discussion (Misc queries)	6	November 13th 06 03:35 PM
Stupid Question	mastermind	Excel Worksheet Functions	1	August 5th 06 07:03 PM
Stupid List Box Question	Michael Link	Excel Discussion (Misc queries)	4	April 3rd 06 03:06 PM
Stupid counting question!!	NotIT	Excel Discussion (Misc queries)	4	January 19th 06 07:56 PM

All times are GMT +1. The time now is 10:18 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us