Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting question (if cell = 0, wrap cell in quotes) | New Users to Excel | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions |