converting a number to a text
Please, How Can I make Excel convert a given number in a cell to text
EXAMPLE : 2155.50 L.E to "Two thounsands one hundred and fifty five,50/100 POUNDS" . ALL correct and rapid answers are appreciated. THANKS |
converting a number to a text
Here's one way of doing it:
http://www.sulprobil.com/html/spellnumber.html Hope this helps. Pete On Nov 8, 11:13 pm, SHERRY wrote: Please, How Can I make Excel convert a given number in a cell to text EXAMPLE : 2155.50 L.E to "Two thounsands one hundred and fifty five,50/100 POUNDS" . ALL correct and rapid answers are appreciated. THANKS |
converting a number to a text
Thanks Pete , and I would be so grateful if U send a link showing how to do
it step by step cos I am still a beginner (level 1) and I thought it would be less complicated. any way thanks for your interest. "Pete_UK" wrote: Here's one way of doing it: http://www.sulprobil.com/html/spellnumber.html Hope this helps. Pete On Nov 8, 11:13 pm, SHERRY wrote: Please, How Can I make Excel convert a given number in a cell to text EXAMPLE : 2155.50 L.E to "Two thounsands one hundred and fifty five,50/100 POUNDS" . ALL correct and rapid answers are appreciated. THANKS |
converting a number to a text
Here's another link that gives two other ways of achieving it as well
as other links, and you can download example workbooks: http://www.xldynamic.com/source/xld.xlFAQ0004.html Hope this helps. Pete On Nov 12, 7:51 pm, SHERRY wrote: Thanks Pete , and I would be so grateful if U send a link showing how to do it step by step cos I am still a beginner (level 1) and I thought it would be less complicated. any way thanks for your interest. "Pete_UK" wrote: Here's one way of doing it: http://www.sulprobil.com/html/spellnumber.html Hope this helps. Pete On Nov 8, 11:13 pm, SHERRY wrote: Please, How Can I make Excel convert a given number in a cell to text EXAMPLE : 2155.50 L.E to "Two thounsands one hundred and fifty five,50/100 POUNDS" . ALL correct and rapid answers are appreciated. THANKS- Hide quoted text - - Show quoted text - |
All times are GMT +1. The time now is 09:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com