Blank dates showing as 00 january 1900 - help

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

Ms-Exl-Learner

=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!
 
D

David Biddulph

=IF(VLOOKUP(B8,'Summary '!B2:$K$100,10,FALSE)=0,"",VLOOKUP(B8,'Summary
'!B2:$K$100,10,FALSE))
 
J

Josuha

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!
 

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

Top