Convert % to Numbers

[pgerardi]

Hi I have a series of numbers for a chart that are all %s eg 55%. I need to change them to numbers where the result would be 55. If I do a format it comes out to .55. Is there format for this or do I have to do a calculation on each number to convert. Looking for a time saving way.

Thanks

 

[rlv01]

You'll need to multiply the % value by 100 to convert 55% (0.55) to 55. And change the cell formatting unless you want it to display 5500%.

 

[Burrgogi]

Hi I have a series of numbers for a chart that are all %s eg 55%. I need to change them to numbers where the result would be 55. If I do a format it comes out to .55. Is there format for this or do I have to do a calculation on each number to convert. Looking for a time saving way.

Thanks

Let me see if I understand this correctly. You have a column of data that looks like this:
55%
50%
62%
etc.

And you want it to look like this?
55
50
62

If so, then copy & paste this formula into a blank column.
=A1*100

Change "A1" to whatever column that actually contains your data. Then fill down remainder of the column.

 

[Alex Blakenburg]

Another option if you don't want to use a formula is:
• Put 100 in an empty Cell
• Hit Copy
• Select the cells with your % in them
• Paste > Special > Multiply

This will take the format from the cell with the 100 in it for your % cells.
So if you want a set number of decimals or a certain negative value look then format that cell first, if you are happy with General then use that.

 

[Burrgogi]

Another option if you don't want to use a formula is:
• Put 100 in an empty Cell
• Hit Copy
• Select the cells with your % in them
• Paste > Special > Multiply

This will take the format from the cell with the 100 in it for your % cells.
So if you want a set number of decimals or a certain negative value look then format that cell first, if you are happy with General then use that.

That's even better! I forgot about that option.

 

[Alex Blakenburg]

@Burrgogi, so many options, so little time .
The choice often depends on how the data gets refreshed though. Pulling in the data from an Input sheet using something like your formula is better for automation, at least without also factoring in using VBA.

 

[pgerardi]

Let me see if I understand this correctly. You have a column of data that looks like this:
55%
50%
62%
etc.

And you want it to look like this?
55
50
62

If so, then copy & paste this formula into a blank column.
=A1*100

Change "A1" to whatever column that actually contains your data. Then fill down remainder of the column.

Thanks so much! That's what I was looking for

Another option if you don't want to use a formula is:
• Put 100 in an empty Cell
• Hit Copy
• Select the cells with your % in them
• Paste > Special > Multiply

This will take the format from the cell with the 100 in it for your % cells.
So if you want a set number of decimals or a certain negative value look then format that cell first, if you are happy with General then use that.

Perfect! Thanks so much, that is what I was looking for. Didn't want to use formulas.

Thanks again.

 

[Alex Blakenburg]

Thanks for letting us know. Glad we could help.