Forum Discussion

jana_d's avatar
jana_d
Copper Contributor
Dec 04, 2020

Excel - percentage

Hi all, I've got a table with some data where few columns are different percentage. I am pasting this percentage every month from my source where are these formatted as numbers. So for example I ha...
excel
millerblair's avatar
millerblair
Iron Contributor
Dec 04, 2020

jana_d Following on from rhancock's good suggestion, when you paste special select 'Values' in the 'Paste' section of the "Paste Special" window and 'Multiply' in the 'Operations" section. This will retain the % formatting of the cells.

Resources