ExcelBanter

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

senthil

excel formula
 
What is the formula to be used in excel to convert the Number to text


Eg : 1250 = One Thousand Two hundred and Fifty only


Paul B

excel formula
 
senthil, have a look here,
http://www.xldynamic.com/source/xld.xlFAQ0004.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"senthil" wrote in message
...
What is the formula to be used in excel to convert the Number to text


Eg : 1250 = One Thousand Two hundred and Fifty only




Bob Phillips

excel formula
 
See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"senthil" wrote in message
...
What is the formula to be used in excel to convert the Number to text


Eg : 1250 = One Thousand Two hundred and Fifty only





All times are GMT +1. The time now is 08:50 PM.

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