Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting text to number | Excel Worksheet Functions | |||
Converting Number to text | Excel Discussion (Misc queries) | |||
Converting A Number To Text | Excel Discussion (Misc queries) | |||
converting text to number | Excel Discussion (Misc queries) | |||
Converting text to a number | Excel Worksheet Functions |