Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Could any one show me how to write a number in words. Which formular can be used? Ex: In A1 : 565 A2 : =(????,A1) = five hundred and sixty-five |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Look he
http://xldynamic.com/source/xld.xlFAQ0004.html -- Kind regards, Niek Otten Microsoft MVP - Excel "minithao" wrote in message ... | | | Could any one show me how to write a number in words. Which formular can be | used? | | Ex: In A1 : 565 | A2 : =(????,A1) = five hundred and sixty-five |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
In case you need to convert number to words with formula (No VBA Codes), you
can download "spellnoformula" (scroll to 4) from below webpage. You can have 5 options to select. http://in.geocities.com/shahshaileshs/misc.htm Regards, Shailesh Shah http://in.geocities.com/shahshaileshs/ If You Can't Excel with Talent, Triumph with Effort. Free Addins Office Menu-2003 for Office-2007 http://in.geocities.com/shahshaileshs/menuaddins "minithao" wrote in message ... Could any one show me how to write a number in words. Which formular can be used? Ex: In A1 : 565 A2 : =(????,A1) = five hundred and sixty-five |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HOW TO WRITE NUMBERS IN WORDS(ENGLISH) | Excel Discussion (Misc queries) | |||
How can I write for extensive a number (Excel) ? | Excel Worksheet Functions | |||
Formula Convert Digits to Words (1000 write One thousand) | Excel Worksheet Functions | |||
How to write figures in words form? | Excel Discussion (Misc queries) | |||
can excel convert number into words (like 10 to ten)? | Excel Worksheet Functions |