Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |