View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Adam Kroger
 
Posts: n/a
Default Function debug help please

I need a cell to display the number 0703 not 703. All instances of this
cell type will be 4 digits.

The number is entered on one sheet, and then located and returned by a
Vlookup on another

I am using a MID() on the VLOOKUP() cell, and need it to return 7 instead of
70.