2009/12/14 <[email protected]> > Sir, > > I want to know that how can I get a text (character) to a numeric value. > Say "201" to be as "Two Hundred and One" or "Two Zero One". > ie. if a Cell (Say A1) is entered with a numeric value "21" then in Cell > (say B1) will display "Two Hundred and One" or "Two Zero One". > > Thanks to all for the support always extended. > > With Regards, > > SUBRATA NATH > SNX27, Silchar. > > Please see the discussion at < http://www.oooforum.org/forum/viewtopic.phtml?t=5923>. You can copy/paste the OOo Basic macro into your own library and, if you wish, assign a key to it. Note that I cannot vouch for the correct working of the code.
For OOo 2.x, see http://documentation.openoffice.org/manuals/oooauthors2/0312CG-CalcMacros.pdffor details of installing macros. This should also work in 3.x -- Harold Fuchs London, England Please reply *only* to [email protected]
