when setting a cell to equal a blank cell it displays 0
 

If I make cell A1=B1 the result in A1 is 0 (zero) if B1 is blank. Is it
possible to have a blank result in A1? I am trying to create a template where
I have some cells equate to others and I would like the cells to show blank
if there is no data in the target cells.

when setting a cell to equal a blank cell it displays 0
 

Try to format the cell as such:
_(* #,##0.00_);_(* (#,##0.00);_(* ""??_);_(@_)

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"BWildeRed" wrote:

If I make cell A1=B1 the result in A1 is 0 (zero) if B1 is blank. Is it
possible to have a blank result in A1? I am trying to create a template where
I have some cells equate to others and I would like the cells to show blank
if there is no data in the target cells.

when setting a cell to equal a blank cell it displays 0
 

Try this...

=IF(B1="","",B1)

--
Biff
Microsoft Excel MVP


"BWildeRed" wrote in message
...
If I make cell A1=B1 the result in A1 is 0 (zero) if B1 is blank. Is it
possible to have a blank result in A1? I am trying to create a template
where
I have some cells equate to others and I would like the cells to show
blank
if there is no data in the target cells.