Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date from imported file
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date from imported file
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(). "CaroleO" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dealing with csv imported file in excel | Excel Discussion (Misc queries) | |||
imported doc from pdf file, want to seperate text & date in cells | Excel Discussion (Misc queries) | |||
CSV file Imported to Excel | Excel Discussion (Misc queries) | |||
can I display the file name of the imported text file in another c | Excel Discussion (Misc queries) | |||
Macros disappear after a file is imported | Excel Discussion (Misc queries) |