ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Number value to text as percentile (https://www.excelbanter.com/excel-programming/273634-number-value-text-percentile.html)

N Lennox

Number value to text as percentile
 
I need a macro that will convert number values to text as
percentile. For example:

24 will be twenty-fourth
56 will be fifty-sixth
12 will be twelfth
87 will be eighty-seventh

etc.

Any help you could provide would be great.

http://support.microsoft.com/default.aspx?scid=kb;en-
us;213360

is a good starting point but insufficient.



Tom Ogilvy

Number value to text as percentile
 
Why not just modify it to meet your needs.

Regards,
Tom Ogilvy


N Lennox wrote in message
...
I need a macro that will convert number values to text as
percentile. For example:

24 will be twenty-fourth
56 will be fifty-sixth
12 will be twelfth
87 will be eighty-seventh

etc.

Any help you could provide would be great.

http://support.microsoft.com/default.aspx?scid=kb;en-
us;213360

is a good starting point but insufficient.





N Lennox

Number value to text as percentile
 
I was hoping someone had already done it. Seems likely.

-----Original Message-----
Why not just modify it to meet your needs.

Regards,
Tom Ogilvy


N Lennox wrote in message
...
I need a macro that will convert number values to text

as
percentile. For example:

24 will be twenty-fourth
56 will be fifty-sixth
12 will be twelfth
87 will be eighty-seventh

etc.

Any help you could provide would be great.

http://support.microsoft.com/default.aspx?scid=kb;en-
us;213360

is a good starting point but insufficient.




.



All times are GMT +1. The time now is 05:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com