View Single Post
 
Old 11-11-2015, 08:10 AM
Officer_Bierschnitt Officer_Bierschnitt is offline Windows 7 64bit Office 2013
Advanced Beginner
 
Join Date: Oct 2015
Posts: 87
Officer_Bierschnitt is on a distinguished road
Default Row was formatted as % - reformat?

Hi,

I just found a file today where I was supposed to input some figures and I noticed the figures there, which should be amounts, are for some reason formatted as %. So, it says, for example, 25,2% - that should be €25,2.

=> How can I quickly reformat that? When i simply use the regular formatting options (Ctrl+1) and change that to > currency < - then because of the % it changes into €0,25. So I have to somehow multiply it with 100 at the same time.
Is there any way to do that quickly?

Thanks a lot!

Best regards,

Officer_Bierschnitt
Reply With Quote