ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   convert numaricalto character (https://www.excelbanter.com/excel-discussion-misc-queries/206069-convert-numaricalto-character.html)

shanil

convert numaricalto character
 
hi
I would like a set up a formula to convert numarical data like (1 or 55) to
character like (one or fiftyfive).
Is there is any formula for that.....?????

Gary''s Student

convert numaricalto character
 
Consider using a VLOOKUP() table. See Excel Help.
--
Gary''s Student - gsnu200806


"shanil" wrote:

hi
I would like a set up a formula to convert numarical data like (1 or 55) to
character like (one or fiftyfive).
Is there is any formula for that.....?????


Stefi

convert numaricalto character
 
See http://support.microsoft.com/kb/213360

Regards,
Stefi

€˛shanil€¯ ezt Ć*rta:

hi
I would like a set up a formula to convert numarical data like (1 or 55) to
character like (one or fiftyfive).
Is there is any formula for that.....?????



All times are GMT +1. The time now is 10:17 AM.

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