Date from imported file

[Guest]

I have an imported file. The date of the file in D4 is 02/08/2007 -
02/15/2007. I am matching rows to each date, and to capture the beginning
date, in Q4 I have a formula =LEFT(D4,10). The result is 02/08/2007. Q1 =
Q4 (but formatted to drop the leading 0's). Here is the problem. When I put
in the formula =IF($B18=$Q1,$K18,"") I get a blank. But - if I TYPE in
2/8/2007 in Q1, I get the contents of B18. I have copied Q1 and past special
/ values - still get a blank.

Any ideas?

CaroleO

 

[Guest]

I think you havve two problems

1) to get leading zeroes in date youcan uuse a custom format in the format
Menu under numbers custom. Creatte a custom format mm/dd/yyyy. You are only
get one 'm' not two 'mm'. You can also do this with the Text() function and
put the custom format into this function

2) The second problem you are having is mixing a string format containng the
time and a time format. You cannot take a time formatt and use the string
function Left().