| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return blank cell if data cell is blank | Excel Worksheet Functions | |||
| how can i fill data in blank cells after copying a pivot report? | Excel Discussion (Misc queries) | |||
| finding last non-blank cell and then copying it to the next cell | Excel Discussion (Misc queries) | |||
| Copying a Blank Cell | Excel Worksheet Functions | |||
| Automatic copying data excluding blank cells | Excel Worksheet Functions | |||
Threaded Mode
