Thanks HighTide and GG,
I'll give it a try, your help is much appreciated.

"HighTide" wrote:

There are several ways to do this
=value(A1) will drop the zeroes
=""&value(A1) or =text(value(A1),0)
Converts it back to text.

Does this help?
You will still have match text in your functions.
For examaple =match(1,range,0) will return #N/A
but =match("1",range,0) will find your text version of 1 after you
strip the zeroes.


On Sat, 26 Feb 2005 12:49:02 -0800, "HeatherO"
wrote:

I am trying to do a vlookup between 2 spreadsheets and in the one the data is
stored as text and the other as a number with leading zeros (ie. 001) when I
change the format to text it keeps the 001 so I was just wondering if there
is some code to strip the leading zeros out before I reformat the numbers to
text. Your help is appreciated.
TIA
Heather