Excel 2007 - pasting into cell changes format
Posted on 2010-11-24
I can't stand how when I copy and paste long numbers into excel the format of the cell changes so that it either changes the last digit to 0 or puts it into scientific notation. So then what I have to do is go to the column, select it and change the format to text and then go through each and every cell to correct the value of the cell to the correct number.
I'm using credit card numbers so this happens ALL THE TIME!!!
It is equally as frustrating when excel rounds off the dollar amounts (or euros) so that when I paste in 2000.00 it rounds it to 2000 or when I paste in 444.40 and it rounds it to 444.4. (I need two decimal places showing when I click in the cell)
Is there a way to make permanent the formatting of a column, or a page,, so that when values are pasted into it by any means whether that be by copy and paste or by macro or function the format of the pasted-into-spreadsheet does not change?
Drives me nuts!