I am working with an excel file that has multiple sheets-different views
for different people. However, there is one main sheet that pulls in
data from the other sheets for a consolidated view

My problem is when I create a cell reference, the format is displayed
even when the cell referred to is blank. So for example, if I have a
cell that is formatted to be a date, but does not have data in it yet,
the corresponding cell on the main sheet shows 1/1/00. I want this cell
to be just blank till the time I have real data entered--anyway of doing
this??
Please help!


--
exploringexcel
------------------------------------------------------------------------
exploringexcel's Profile: http://www.excelforum.com/member.php...o&userid=26356
View this thread: http://www.excelforum.com/showthread...hreadid=398185