how do i get the mid function to work with a zero
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
|