If I drag data to another cell, it takes away the formatting in the old cell.
For example, say I have a cell formatted to show negative numbers in
parenthesis (eg: -4 = (4.00)) and I drag that to another cell, if I enter new
data in the original cell I dragged from, the formatting is gone. Is there a
way to avoid this without creating a macro?