Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell display
Due to a print formatting issue I am trying to copy the contents of one cell
to another. If the original cell is blank, I want the duplicate cell to be blank. If the original cell contains a numeric value, I want the duplicate cell to contain the numeric value to two decimal places. How do I format the duplicate cell to achieve this? Thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell display
On Sat, 27 Dec 2008 16:42:00 -0800, Willy
wrote: Due to a print formatting issue I am trying to copy the contents of one cell to another. If the original cell is blank, I want the duplicate cell to be blank. If the original cell contains a numeric value, I want the duplicate cell to contain the numeric value to two decimal places. How do I format the duplicate cell to achieve this? Thanks If A1 is the original cell, try the following formula in the duplicate cell: =IF(A1="","",A1) Format the duplicate cell as number with two decimals. Hope this helps / Lars-Åke |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell display
Hi,
=IF(A1,A1,"") Assuming the cell you want to test is A1 then in another cell enter the formula above. Note the cell is not really blank, it contains a formula which displays as blank. If this helps, please click the Yes button. Cheers, Shane Devenshire "Willy" wrote in message ... Due to a print formatting issue I am trying to copy the contents of one cell to another. If the original cell is blank, I want the duplicate cell to be blank. If the original cell contains a numeric value, I want the duplicate cell to contain the numeric value to two decimal places. How do I format the duplicate cell to achieve this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display contents of cell if adjacent cell equals | Excel Worksheet Functions | |||
find last cell in range with data, display cell address | Excel Worksheet Functions | |||
display text in one cell as a number in an adjacent cell in excel | New Users to Excel | |||
Display contents of cell in another cell as part of text string? | New Users to Excel | |||
How to click on a cell and have the content of the cell display in a different cell | Excel Worksheet Functions |