![]() ![]() ReDim Arr(1 To Selection.SpecialCells(xlCellTypeFormulas). It does not modify the workbook at all, so if your user messes up and selects the wrong column there is no impact to your data. I'm assuming that the values are all calculated with formulas, and that there aren't any blank cells. You can make a button, assign a hotkey or manually run it via the ribbon. ![]() After the macro runs the data will be on the Clipboard. Usage: Select the range (you can select the entire column) and invoke the macro via whatever method is easiest for your user. and browse to and add C:\Windows\System32\FM20.DLL. If you don't see it (they are listed alphabetically), you'll need to add it via the dll. Scroll down until you see Microsoft Forms 2.0 Object Library and check the box next to it and click OK. Press Alt+F11 to bring up the Visual Basic Editor, then click on Tools > References. If you display that as percentage, it gets multiplied by 100 again. If your calculation is producing a result of 38, you're already multiplying it by 100 within that calculation or starting with units that are already percentages. But first, you must add a reference to the Microsoft Forms 2.0 library. IanScott, percentage takes a decimal fraction and multiplies it by 100 to display it as units of percent. You can use this Macro to get the job done. I found a blog (Chandoo) that suggests using a format like #,#.# % to hide the percentage sign below a new line, but that doesn't work for me since I need clean output for the application my users will copy and paste the output into. The magic "Percentage" number format, which multiplies by 100, appear to be listed in custom formats as 0.00%, but simply removing the % also removes the multiplication. Is there any number format or similar presentation layer modification that will allow me to take data stored like 0.75, 0.5, 0.25 and copy and paste it into another application like 75, 50, 25? I want to avoid these because these sheets are complex, they're maintained by a team other than the person doing this process, and I don't want the person doing this process changing the actual content of the sheet beyond an easily reversible presentational change like a new number format. Obviously without this limitation, adding a column with a formula like =A1*100 would be very easy. I'd like to do it without any modifications to the content or structure of the sheet, so, no new columns, and no changes to the underlying data. I'm setting up a process for transferring such data to another program (Adobe Illustrator) which trips up if numbers contain any symbol (even %). I have data which is in a format where, for example, a cell whose raw content is 0.75 "means" 75%. This is the opposite to the question Number format in excel: Showing % value without multiplying with 100. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |