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
rhancock's avatar
rhancock
Brass Contributor
Dec 04, 2020

jana_d 

 

Type "0.01" into a blank cell anywhere (do not use quotes)

Copy the cell which has 0.01

Highlight/select all of the cells showing 4500%

Paste Special - Multiply

 

Also, you might have better luck in the future in the Excel forum 🙂

The Microsoft Excel Community

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