0/01/1900

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please help! date showing as 1900/01/00 2
max value 1
Problem with Date format 2
00/01/1900 1
supress 01-01-1900 3
Help with counting between dates 4
Dates before 1900 2
Access Running Balance in Access 1

Back
Top