View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.