Thread: Format Cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pran Pran is offline
external usenet poster
 
Posts: 26
Default Format Cell

Hi,

I m using vlookup function which is result is date for each cell and i
already formatted my workbook with date category.

How ever, not every cell in my source has a date, many of datas are blank
and result shows "0-Jan-00" rather than "-" or just "blank".

How can I change this?

Any help is much appreciated.