View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
garbold
 
Posts: n/a
Default how do i get the mid function to work with a zero

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