=text(A1,"0000")

--
Kind regards,

Niek Otten

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
. ..
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.