ExcelBanter - Convert Percentage to Text

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Convert Percentage to Text (https://www.excelbanter.com/excel-discussion-misc-queries/47509-convert-percentage-text.html)

Kinjalip

Convert Percentage to Text

Does anyone know if there is a way, outside of writing a macro to convert
percentages to just text? Example with 17.0% convert to just 17.

Thanks
--
Jeffrey L. Lippard, A+ certified, CHDP certified

Bernard Liengme

=A1*100 ?

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kinjalip" wrote in message
...
Does anyone know if there is a way, outside of writing a macro to convert
percentages to just text? Example with 17.0% convert to just 17.

Thanks
--
Jeffrey L. Lippard, A+ certified, CHDP certified

Bob Phillips

Multiply by 100 and format as General.

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Kinjalip" wrote in message
...
Does anyone know if there is a way, outside of writing a macro to convert
percentages to just text? Example with 17.0% convert to just 17.

Thanks
--
Jeffrey L. Lippard, A+ certified, CHDP certified

All times are GMT +1. The time now is 12:49 AM.