View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Frank Situmorang Frank Situmorang is offline
external usenet poster
 
Posts: 97
Default confused about date format

I used vlookup to show date in another sheet. in the original sheet it the
date is blank, but in the other sheet as a result of the vlookup, the date is
"00-Jan_00" for the blank date in the original sheet.

My question is how can I show it as original sheet showing it blank (not
00-Jan-00)

Many thanks for any idea

Frank