freezing formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be able to "freeze" the formatting for the number of decimal places in cells - some will need to be integers, some will need three decimal places, etc. The problem comes when I paste in information; the number of decimal places I have formatted the cell for is overridden by the pasted-in data. Any ideas?
 
I would like to be able to "freeze" the formatting for the number of decimal places in cells - some will need to be integers, some will need three decimal places, etc. The problem comes when I paste in information; the number of decimal places I have formatted the cell for is overridden by the pasted-in data. Any ideas?
Click to expand...

The most obvious one is to paste special -> paste as values rather
than simply pasting the new data. That will leave your original
formatting in place. You can customise your standard toolbar to
include an icon for doing that.
 
Back
Top