Excel - percentage

%3CLINGO-SUB%20id%3D%22lingo-sub-1956201%22%20slang%3D%22en-US%22%3EExcel%20-%20percentage%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1956201%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3EI've%20got%20a%20table%20with%20some%20data%20where%20few%20columns%20are%20different%20percentage.%20I%20am%20pasting%20this%20percentage%20every%20month%20from%20my%20source%20where%20are%20these%20formatted%20as%20numbers.%3C%2FP%3E%3CP%3ESo%20for%20example%20I%20have%2045%20in%20my%20source%20and%20want%20to%20copy%20that%20and%20paste%20it%20to%20my%20excel%20table%20as%2045%25.%20However%2C%20when%20I%20do%20this%20it%20displays%20as%204500%25%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20how%20to%20paste%20it%20as%20a%2045%25%20without%20the%20need%20of%20formula%20or%20changing%20the%20source%20to%200.45%3F%3C%2FP%3E%3CP%3EThan%20you%20for%20any%20advise%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1956201%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1957543%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20percentage%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1957543%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F891059%22%20target%3D%22_blank%22%3E%40jana_d%3C%2FA%3E%20the%20easiest%20would%20be%20to%20use%20a%20formula%20to%20transform%20the%20source%20data%20before%20copying.%20There%20is%20no%20way%20to%20do%20it%20directly%20through%20copy-paste.%20If%20you%20format%20the%20cells%20as%20percentages%20before%20typing%20in%20data%2C%20you%20can%20manually%20enter%20a%20whole%20number%2C%20but%20this%20doesn't%20work%20for%20copy%20paste.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1957545%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20percentage%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1957545%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F891059%22%20target%3D%22_blank%22%3E%40jana_d%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EType%20%220.01%22%20into%20a%20blank%20cell%20anywhere%20(do%20not%20use%20quotes)%3C%2FP%3E%3CP%3ECopy%20the%20cell%20which%20has%200.01%3C%2FP%3E%3CP%3EHighlight%2Fselect%20all%20of%20the%20cells%20showing%204500%25%3C%2FP%3E%3CP%3EPaste%20Special%20-%20Multiply%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20you%20might%20have%20better%20luck%20in%20the%20future%20in%20the%20Excel%20forum%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fct-p%2FExcel_Cat%22%20target%3D%22_blank%22%3EThe%20Microsoft%20Excel%20Community%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 have 45 in my source and want to copy that and paste it to my excel table as 45%. However, when I do this it displays as 4500%

Is there a way how to paste it as a 45% without the need of formula or changing the source to 0.45?

Than you for any advise

 

3 Replies

@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

@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.

Thank you both @rhancock and @millerblair, this works perfectly!