I am having an issue with formatting on my table.
I copy a row from one sheet (downloaded from online) and paste into another sheet on my table. If I paste using match destination format or values only it pastes the way I want to and doesn't affect the formatting. If I paste like normal (Ctrl+V) or enable editing in the downloaded sheet then copy and paste, the format changes. I tried format painter, but it doesn't change to the format I want. However the weird thing is I click on the cell to edit it (F2 or double click cell) and select or enter out of it, it changes to the correct format.
Any thoughts as to why it does that?
I copy a row from one sheet (downloaded from online) and paste into another sheet on my table. If I paste using match destination format or values only it pastes the way I want to and doesn't affect the formatting. If I paste like normal (Ctrl+V) or enable editing in the downloaded sheet then copy and paste, the format changes. I tried format painter, but it doesn't change to the format I want. However the weird thing is I click on the cell to edit it (F2 or double click cell) and select or enter out of it, it changes to the correct format.
Any thoughts as to why it does that?