On Saturday 22 January 2005 00:04, + Dante Barboza/IRASA wrote: > [ MODERATED ] ******************** > Hello. I am trying to design a spreadsheet with a formula or Macro that > transforms Numbers into Letters in both English (US Dollars) and Spanish > (Pesos). Can somebody help me? Example: > 9;876,543.21 > in USD... > (NINE MILLIONS EIGHT HUNDRED AND SEVENTY SIX THOUSAND FIVE HUNDRED AND > FOURTY THREE DOLLARS WITH 21/100 USD) > > in Mexican Pesos... > (NUEVE MILLONES OCHOCIENTOS SETENTA Y SEIS MIL QUINIENTOS CUARENTA Y TRES > PESOS CON 21/100 M.N.)
Hi Dante, As you are not subscribed you may not have seen that: On Tuesday 25 January 2005 04:06, Andrew Douglas Pitonyak wrote: > > I spent a few hours and threw together a macro that will do most of what > you want.... Download my free macro document (I have not built the PDF > version yet) Read section 5.27.1 that is titled "Convert number to > words". This does not do exactly what you want, but I ran out of time to > work on it. It will convert positive integers from 0 to 10^303 into > English words. > -- > Andrew Pitonyak > My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw > My Macro Book: http://www.hentzenwerke.com/catalog/oome.htm > Free Info: �http://www.pitonyak.org/oo.php Please reply to [email protected] only. -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
