Cell formatting
 

For print formatting purposes I need to duplicate a keyed in numeric value
from one cell (say A4) into another cell (say Z4). In many cases the
original cell (A4) will be blank. How do I make the duplicate cell (Z4)
remain blank also? Right now I end up with the original cell (A4) as blank
and the duplicate cell (Z4) as a 0 value. If I do put an entry into the
original cell, it will be numeric (say 1.3). The duplicate cell will have
the same number of significant digits as the original cell.

Cell formatting
 

On Sat, 27 Dec 2008 17:04:00 -0800, FatBob
wrote:

For print formatting purposes I need to duplicate a keyed in numeric value
from one cell (say A4) into another cell (say Z4). In many cases the
original cell (A4) will be blank. How do I make the duplicate cell (Z4)
remain blank also? Right now I end up with the original cell (A4) as blank
and the duplicate cell (Z4) as a 0 value. If I do put an entry into the
original cell, it will be numeric (say 1.3). The duplicate cell will have
the same number of significant digits as the original cell.

Try this formula in cell Z4:

=IF(A4="","",A4)

Hope this helps / Lars-Åke

Cell formatting
 

Hi,

In cell Z4 enter the formula

=IF(A4,A4,"")

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"FatBob" wrote in message
...
For print formatting purposes I need to duplicate a keyed in numeric value
from one cell (say A4) into another cell (say Z4). In many cases the
original cell (A4) will be blank. How do I make the duplicate cell (Z4)
remain blank also? Right now I end up with the original cell (A4) as
blank
and the duplicate cell (Z4) as a 0 value. If I do put an entry into the
original cell, it will be numeric (say 1.3). The duplicate cell will have
the same number of significant digits as the original cell.