It's going from one workbook to another that has the problem. If pasting from one sheet to another within the same spreadsheet, then "match destination formatting" is not there, "paste values" is, and that works fine. Granted, I've only tested this on one machine, but it has happened multiple times to me. The result? That column with # will have VALUES of #!!!! You can't expand it wider, you can't format the column with date\number to fix it, the numeric represntation of that data is simply GONE.This corresponds fairly closely to "paste values" which I used to use all the time in Excel 20. Paste the data, choosing to Match Destination Formatting.Copy the data from the spreadsheet, while it is displaying # in that column.For the sake of testing, you may choose to add formatting such as bold, italics, underline, whatever.Set up a spreadsheet with a column that holds either a date or a number in it that is wide enough to cause # to display if you narrow the column's width too far. that is post SP1, and saw this behavior prior to SP1 as well
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |