Removing % sign, but keeping the formatting

[Guest]

I have data generated from another source that is all or mostly percents. I
need to remove the % signs before I put it into yet another program, but just
removing the percent number format turns 56% into 0.56, which doesn't work
for me either. I need it to display as just 56. Is there a way to keep the
percent formatting without actually having the percent sign? Also, I need
this to work for a large workbook with many, many worksheets.

Thanks!

 

[VBA Noob]

You could try this

=SUBSTITUTE(G28,"%","")*100


VBA Noob

 

[VBA Noob]

Or use Text to Columns.

Tick the other and insert the %

Or 56% *100

VBA Noob