#1
|
|||
|
|||
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 |
|
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 |
Loop through Word doc to find and reformat text | Sandy27 | Word VBA | 5 | 01-06-2014 03:48 PM |
Reformat line lengths | joe925 | Word | 1 | 03-18-2013 05:06 PM |
reformat file | renato | Word | 1 | 06-13-2012 06:32 AM |