On Thu, 26 Apr 2007 02:18:05 -0700, Frank Situmorang
wrote:

Ron:

I am just curious to know why is it showing "0-Jan-00" while in the original
sheet it is blank. Your suggestion of using conditional format is a good
option. Thank you very much.

Frank

Frank,

When you refer to a range reference, you return its "value". The value of a
blank cell is zero. Zero in the date system is the above date.




--ron