Cell reference

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!

Bruce,

Thanks for your helped--that worked!

Example..
=IF(LEN(Sheet2!B2)=0,"",Sheet2!B2)
vs.
=Sheet2!B2
will only show a value if there is something in Sheet2, Cell B2.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"exploringexcel" wrote:

>
> 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
>
>

Instead of =A1 try

=if(isblank(A1),"",A1)

- John Michl

Example..
=IF(LEN(Sheet2!B2)=0,"",Sheet2!B2)
vs.
=Sheet2!B2
will only show a value if there is something in Sheet2, Cell B2.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"exploringexcel" wrote:

>
> 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
>
>

Example..
=IF(LEN(Sheet2!B2)=0,"",Sheet2!B2)
vs.
=Sheet2!B2
will only show a value if there is something in Sheet2, Cell B2.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"exploringexcel" wrote:

>
> 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
>
>

Example..
=IF(LEN(Sheet2!B2)=0,"",Sheet2!B2)
vs.
=Sheet2!B2
will only show a value if there is something in Sheet2, Cell B2.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"exploringexcel" wrote:

>
> 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
>
>

Instead of =A1 try

=if(isblank(A1),"",A1)

- John Michl

Instead of =A1 try

=if(isblank(A1),"",A1)

- John Michl

Instead of =A1 try

=if(isblank(A1),"",A1)

- John Michl

Example..
=IF(LEN(Sheet2!B2)=0,"",Sheet2!B2)
vs.
=Sheet2!B2
will only show a value if there is something in Sheet2, Cell B2.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"exploringexcel" wrote:

>
> 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
>
>

Instead of =A1 try

=if(isblank(A1),"",A1)

- John Michl

Example..
=IF(LEN(Sheet2!B2)=0,"",Sheet2!B2)
vs.
=Sheet2!B2
will only show a value if there is something in Sheet2, Cell B2.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"exploringexcel" wrote:

>
> 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
>
>

Example..
=IF(LEN(Sheet2!B2)=0,"",Sheet2!B2)
vs.
=Sheet2!B2
will only show a value if there is something in Sheet2, Cell B2.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"exploringexcel" wrote:

>
> 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
>
>

Instead of =A1 try

=if(isblank(A1),"",A1)

- John Michl

Instead of =A1 try

=if(isblank(A1),"",A1)

- John Michl

Example..
=IF(LEN(Sheet2!B2)=0,"",Sheet2!B2)
vs.
=Sheet2!B2
will only show a value if there is something in Sheet2, Cell B2.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"exploringexcel" wrote:

>
> 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
>
>

Example..
=IF(LEN(Sheet2!B2)=0,"",Sheet2!B2)
vs.
=Sheet2!B2
will only show a value if there is something in Sheet2, Cell B2.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"exploringexcel" wrote:

>
> 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
>
>

Example..
=IF(LEN(Sheet2!B2)=0,"",Sheet2!B2)
vs.
=Sheet2!B2
will only show a value if there is something in Sheet2, Cell B2.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"exploringexcel" wrote:

>
> 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
>
>

Instead of =A1 try

=if(isblank(A1),"",A1)

- John Michl

Instead of =A1 try

=if(isblank(A1),"",A1)

- John Michl

Instead of =A1 try

=if(isblank(A1),"",A1)

- John Michl

Example..
=IF(LEN(Sheet2!B2)=0,"",Sheet2!B2)
vs.
=Sheet2!B2
will only show a value if there is something in Sheet2, Cell B2.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"exploringexcel" wrote:

>
> 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
>
>

Example..
=IF(LEN(Sheet2!B2)=0,"",Sheet2!B2)
vs.
=Sheet2!B2
will only show a value if there is something in Sheet2, Cell B2.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"exploringexcel" wrote:

>
> 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
>
>

Example..
=IF(LEN(Sheet2!B2)=0,"",Sheet2!B2)
vs.
=Sheet2!B2
will only show a value if there is something in Sheet2, Cell B2.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"exploringexcel" wrote:

>
> 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
>
>

Example..
=IF(LEN(Sheet2!B2)=0,"",Sheet2!B2)
vs.
=Sheet2!B2
will only show a value if there is something in Sheet2, Cell B2.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"exploringexcel" wrote:

>
> 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
>
>

Instead of =A1 try

=if(isblank(A1),"",A1)

- John Michl

Instead of =A1 try

=if(isblank(A1),"",A1)

- John Michl

Instead of =A1 try

=if(isblank(A1),"",A1)

- John Michl

Instead of =A1 try

=if(isblank(A1),"",A1)

- John Michl

Example..
=IF(LEN(Sheet2!B2)=0,"",Sheet2!B2)
vs.
=Sheet2!B2
will only show a value if there is something in Sheet2, Cell B2.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"exploringexcel" wrote:

>
> 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
>
>

Instead of =A1 try

=if(isblank(A1),"",A1)

- John Michl

Example..
=IF(LEN(Sheet2!B2)=0,"",Sheet2!B2)
vs.
=Sheet2!B2
will only show a value if there is something in Sheet2, Cell B2.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"exploringexcel" wrote:

>
> 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
>
>

Example..
=IF(LEN(Sheet2!B2)=0,"",Sheet2!B2)
vs.
=Sheet2!B2
will only show a value if there is something in Sheet2, Cell B2.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"exploringexcel" wrote:

>
> 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
>
>

Example..
=IF(LEN(Sheet2!B2)=0,"",Sheet2!B2)
vs.
=Sheet2!B2
will only show a value if there is something in Sheet2, Cell B2.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"exploringexcel" wrote:

>
> 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
>
>

Example..
=IF(LEN(Sheet2!B2)=0,"",Sheet2!B2)
vs.
=Sheet2!B2
will only show a value if there is something in Sheet2, Cell B2.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"exploringexcel" wrote:

>
> 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
>
>

Example..
=IF(LEN(Sheet2!B2)=0,"",Sheet2!B2)
vs.
=Sheet2!B2
will only show a value if there is something in Sheet2, Cell B2.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"exploringexcel" wrote:

>
> 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
>
>

Instead of =A1 try

=if(isblank(A1),"",A1)

- John Michl

Instead of =A1 try

=if(isblank(A1),"",A1)

- John Michl

Instead of =A1 try

=if(isblank(A1),"",A1)

- John Michl

Instead of =A1 try

=if(isblank(A1),"",A1)

- John Michl

Instead of =A1 try

=if(isblank(A1),"",A1)

- John Michl

Example..
=IF(LEN(Sheet2!B2)=0,"",Sheet2!B2)
vs.
=Sheet2!B2
will only show a value if there is something in Sheet2, Cell B2.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"exploringexcel" wrote:

>
> 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
>
>

Instead of =A1 try

=if(isblank(A1),"",A1)

- John Michl

Example..
=IF(LEN(Sheet2!B2)=0,"",Sheet2!B2)
vs.
=Sheet2!B2
will only show a value if there is something in Sheet2, Cell B2.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"exploringexcel" wrote:

>
> 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
>
>

Instead of =A1 try

=if(isblank(A1),"",A1)

- John Michl