Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to make convert a number in words in excel
i want excel to convert any number in words automatically
for example cell A1 total is 100 then in cell A2 excel should put " ONE HUNDRED" |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to make convert a number in words in excel
See any of these:
Bob Phillips' site for help on this. http://www.xldynamic.com/source/xld.xlFAQ0004.html or Bernd Plumhoff's site http://www.sulprobil.com/html/spellnumber.html or http://www.ozgrid.com/VBA/ValueToWords.htm or http://support.microsoft.com/?kbid=213360 best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Keiko" wrote in message ... i want excel to convert any number in words automatically for example cell A1 total is 100 then in cell A2 excel should put " ONE HUNDRED" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert Number into words in EXCEL same or a new cell ? | Excel Worksheet Functions | |||
Excel should have a formula to convert number into words | Excel Worksheet Functions | |||
how to automatically convert a number to words in Excel | Excel Worksheet Functions | |||
I wish excel to convert number to words ie 23 to twenty three | Excel Discussion (Misc queries) | |||
can excel convert number into words (like 10 to ten)? | Excel Worksheet Functions |