Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am using a vlookup to pull a column of dates into another workbook.
However, in some cases the sheet that I pull the date from has a blank in the date column which then populates my vlookup column with a zero value. Because the destination column is formatted as a date, I end up with a 01/00/00 value. Is there a quick and easy way to eliminate this; I'd like to see the blank pulled forward so that if there is no date listed in the source file the destination file is also blank. Thanks in advance, Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
Opening a csv file with US date format on a Australian PC | Excel Discussion (Misc queries) | |||
USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
Date format collapses diagram | Excel Discussion (Misc queries) |