LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Rob Laman
 
Posts: n/a
Default Date format when using a vlookup

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I keep the date from changing format in a mail merge? Brynn Wilson Excel Discussion (Misc queries) 2 February 1st 07 05:19 PM
How do I keep the date from changing format in a mail merge? Brynn Wilson Excel Discussion (Misc queries) 1 June 9th 05 06:44 PM
Opening a csv file with US date format on a Australian PC Troy Lea Excel Discussion (Misc queries) 2 March 16th 05 10:05 PM
USING THE DATE FORMAT IN EXCEL teach Excel Discussion (Misc queries) 3 December 14th 04 11:55 PM
Date format collapses diagram Richard H Excel Discussion (Misc queries) 3 December 14th 04 11:08 PM


All times are GMT +1. The time now is 02:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"