Blank dates showing as 00 january 1900 - help

  • Thread starter Thread starter Josuha
  • Start date Start date
J

Josuha

I'm using the below forumla to import data from a seperate workbook which
contains dates.It does work for cells that have dates in them but not every
cell has a date yet and i want this to remain blank but it shows as 00
january 1900
=VLOOKUP(B8,'Summary '!B2:$K$100,10,FALSE)

Any ideas please?
 
=IF(VLOOKUP(B8,'Summary '!B2:$K$100,10,FALSE)=0,"",VLOOKUP(B8,'Summary
'!B2:$K$100,10,FALSE))

Remember to Click Yes, if this post helps!
 
=IF(VLOOKUP(B8,'Summary '!B2:$K$100,10,FALSE)=0,"",VLOOKUP(B8,'Summary
'!B2:$K$100,10,FALSE))
 
Your a star!
Many thanks (i pressed yes too )

Ms-Exl-Learner said:
=IF(VLOOKUP(B8,'Summary '!B2:$K$100,10,FALSE)=0,"",VLOOKUP(B8,'Summary
'!B2:$K$100,10,FALSE))

Remember to Click Yes, if this post helps!
Click to expand...
 
Back
Top