Solved

# Excel - Format percent back to whole number

Posted on 2011-05-05
297 Views
How do I change an Excel column that is formatted as a percent, back to a whole number?  I changed the format to General which changed it to a decimal - from 50% to .5.  How do I just remove the % and have it read 50?
0
Question by:JT_SIRO
1 Comment

LVL 81

Accepted Solution

You are going to have to multiple the values by 100. Put 100 in an unused cell, press CTRL+V, select the cells to edit, select Edit->Paste Special and check Multiply.

Kevin
0

## Featured Post

### Suggested Solutions

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.