Show percentage as text

  • Thread starter Thread starter EMF
  • Start date Start date
E

EMF

I have made a template in excel that is actually columns of html code.

I then fill in empty columns with various data. Using the excel "&"
function I then create massive html tables quickly, with all the data I
have. The most important thing is that numbers need to be converted to
text.

All has been fine until today when I've been trying to include
percentages.

The column of numbers in the raw data appears as 99%, 100% etc.

If I convert that to text, 100% becomes 1. So that's no good.

So, my problem is I import raw data that shows as a %. I try to change
it to text and 100% becomes 1, when I need 100% to display as 100%.

All I need to create is a line of text.

Can anyone help???

Thanks in advance

~ Erin
 
Hi Erin,

This formula might work:

=your percent cell*100&"%"

Then if you copy & paste special as values it should be formatted as
text...

Laura
 
I have made a template in excel that is actually columns of html code.

I then fill in empty columns with various data. Using the excel "&"
function I then create massive html tables quickly, with all the data I
have. The most important thing is that numbers need to be converted to
text.

All has been fine until today when I've been trying to include
percentages.

The column of numbers in the raw data appears as 99%, 100% etc.

If I convert that to text, 100% becomes 1. So that's no good.

So, my problem is I import raw data that shows as a %. I try to change
it to text and 100% becomes 1, when I need 100% to display as 100%.

All I need to create is a line of text.

Can anyone help???

Thanks in advance
Click to expand...

Have you looked at something like =TEXT(.99,"0%")


--ron
 
Back
Top