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