Blank dates showing as 00 january 1900 - help
 

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?

Blank dates showing as 00 january 1900 - help
 

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

--------------------
(Ms-Exl-Learner)
--------------------


"Josuha" wrote:

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?

Blank dates showing as 00 january 1900 - help
 

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


"Josuha" wrote in message
...
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?

Blank dates showing as 00 january 1900 - help
 

Your a star!
Many thanks (i pressed yes too )

"Ms-Exl-Learner" wrote:

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

--------------------
(Ms-Exl-Learner)
--------------------


"Josuha" wrote:

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?