Hi..thanks for the post it now works...thanks anyway

"Andy" wrote:

Hi
It works for me! It may be that the string is not text, but is a number with
a custom format to show the required number of digits.

Hope this helps.

"garbold" wrote in message
...
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