Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-11-2015, 08:10 AM
Officer_Bierschnitt Officer_Bierschnitt is offline Row was formatted as % - reformat? Windows 7 64bit Row was formatted as % - reformat? Office 2013
Advanced Beginner
Row was formatted as % - reformat?
 
Join Date: Oct 2015
Posts: 79
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to keep formatted form fields after mail merge or replace text with formatted form fields jer85 Word VBA 2 04-05-2015 10:00 PM
Copying and pasting acount data into Excel as text will not reformat to a number or currency ncbergst Excel 3 09-04-2014 11:29 AM
Row was formatted as % - reformat? Loop through Word doc to find and reformat text Sandy27 Word VBA 5 01-06-2014 03:48 PM
Row was formatted as % - reformat? Reformat line lengths joe925 Word 1 03-18-2013 05:06 PM
reformat file renato Word 1 06-13-2012 06:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft