View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
king60611 king60611 is offline
external usenet poster
 
Posts: 9
Default Keep Cell Data Blank when Copying It

This is a silly question for me, but:

I have a column of cells that are currently blank and another column that is
a direct reference to that (i.e., cell AC3=Y3). However, while Y3 remains
blank, AC3 instead reflects a 0. How do I make this remain blank until there
is a value 0 or higher entered into Y3? This is key because I have formulas
referencing AC3 that depend on whether it is blank and the 0 valuation is
skewing that.

Thank you!