FormatCellsNumberCustom

In the type box, enter two semicolons (;) to the end of the formatting
string

--
Kind regards,

Niek Otten


"christmaslog" wrote in message
...
I use vlookup to extract cell which contain date. How do I format it so
that
it will not display any value if the source cell in empty?