Hi thanks have tried that and now it works thanks again

"Marcelo" wrote:

try to format the cell as a text.

regards from Brazil
Marcelo

"garbold" escreveu:

Hi all

I am trying to extract numbers from a test string using the MID function,all
is well until the text string starts with a zero.This is then ignored and
uses the next available number.It is for a barcode generator so the zero is
required.

thanks