Actually the 2 spreadsheets have the same format as number with 0 decimal
places in one of the spreadsheets though the data is stored as '001 and the
other just as 1. The problem is I can not change the data in the one that
has the '001 since it is accessed from another program looking for the 001.
Any solutions would be appreciated like is there away to get rid of the
leading '00 and not anything after since the numbers do go from 1 to 45 '045
and there are some like '040.
TIA
Heather

"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