Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Can anyone advise how do I convert 1,223.35 to ONE THOUSAND TWO HUNDRED
TWENTY THREE DOLLARS AND THIRTY FIVE CENTS? Would prefer to have a formula to do this, instead of via VBA. Thanks!!! |
#2
![]() |
|||
|
|||
![]()
Hi Derrick
there is no inbuilt function for this - you need to use an add-in or code .... check out http://www.xldynamic.com/source/xld.xlFAQ0004.html for details Cheers JulieD "Derrick" wrote in message ... Can anyone advise how do I convert 1,223.35 to ONE THOUSAND TWO HUNDRED TWENTY THREE DOLLARS AND THIRTY FIVE CENTS? Would prefer to have a formula to do this, instead of via VBA. Thanks!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
convert currency to text | Excel Discussion (Misc queries) | |||
convert a numerical currency into word format | Excel Worksheet Functions | |||
convert currency in portuguese words | Excel Worksheet Functions | |||
How do I convert numbers into words in excell worksheet? | Excel Worksheet Functions | |||
how do i convert numbers to words | Excel Worksheet Functions |