If I understand what you mean by "drag and drop" correctly, you can hold
down the Ctrl key while dragging the cell to its new location (actually,
just before you "drop" it will do) and that will copy the cell contents plus
its formatting there while leaving the original data and formatting behind.

Rick


"sramsey" wrote in message
...
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?