Remove leading zeros

[jadell99]

Hi,

I using a tool called QTP (Quick Test Pro) which has an embedded exce
spreadsheet. I am outputting a value to the spreadsheet - the value o
the cell containing the output is =" 00002642". I please need to kno
how to remove the zeros preceding the 2642 as this is number to b
validated

Is there a way to strip either all zeros from a value or trim x numbe
of characters from the beginning of a value?

Thanks for your time and help,
Jaso

 

[Aladin Akyurek]

Try Data|Text to Columns.