On 12/13/2009 08:47 PM, subratan...@punjlloyd.com wrote: > 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".
Louis-Marc may have the answer. This might also be of interest: http://extensions.services.openoffice.org/project/numbertext Refs: http://numbertext.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org