Extract Date

C

christmaslog

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?
 
N

Niek Otten

Format>Cells>Number>Custom

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