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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
formatting question 3
Find/Replace Numbers stored as Text drops zeros 1
Problem with Rounding (2007) 4
Zeros after the decimal 7
Concatenate & Number Formats 2
How can I fill a block of 300 cells with non-repeating random #s 2
Stop XL from changing format? 1

Back
Top