Thread: Cell formatting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
FatBob FatBob is offline
external usenet poster
 
Posts: 1
Default 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.