0/01/1900
 

i have a VLOOKUP formula which returns a date value and i have formatted the
cells to be in date format. however when a value cannot be found (ie. returns
0) the format changes the 0 to 0/01/1900. how can i stop this? id want the
cell to be blank if there is no value.

appreciate your help, thanks!

Hi

=IF(VLOOKUP(...)=0,"",VLOOKUP(...))

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"leolin" wrote in message
...
i have a VLOOKUP formula which returns a date value and i have formatted
the
cells to be in date format. however when a value cannot be found (ie.
returns
0) the format changes the 0 to 0/01/1900. how can i stop this? id want the
cell to be blank if there is no value.

appreciate your help, thanks!

I think I'd use:

=if(vlookup()="","",vlookup())

just in case there was ever a zero that should be returned.



Arvi Laanemets wrote:

Hi

=IF(VLOOKUP(...)=0,"",VLOOKUP(...))

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets

"leolin" wrote in message
...
i have a VLOOKUP formula which returns a date value and i have formatted
the
cells to be in date format. however when a value cannot be found (ie.
returns
0) the format changes the 0 to 0/01/1900. how can i stop this? id want the
cell to be blank if there is no value.

appreciate your help, thanks!

--

Dave Peterson