Removing leading zeros from a group of numbers

Giganews Newsgroups
Subject: Removing leading zeros from a group of numbers
Posted by:  MAC253
Date: Wed, 14 Jun 2006

I have a report that is imported from another source.  A column has numbers
showing as 00047, formatted as "general".  I need to use those numbers in a
vlookup formula - and the lookup table has the numbers without the leading
zeros.  So right now, nothing is pulling.  Is there a way to get rid of those
leading zeros - either by formatting or with a formula - so I can avoid
re-entering them all by hand (there are about 1500 of them).  I use Excel 2000

Replies