| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
=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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert excel file into ASCII text file with alignment? | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Convert excel file to flat text file | Excel Discussion (Misc queries) | |||
| How to convert columns of data to one column of text | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Hybrid Mode
