Hi Dennis, What format will the numbers themselves be entered in?
In addition to "TEXT" you can also use the "DOLLAR" function, which will use your localization information to format the number as text string with a currency symbol, thousands separator and decimal places. To use the "TEXT" function, you can use a format string of "$#,#.##" to get those things as well. I know of no way to get the number written out as words, at least not with stock Calc. This question (see URL [1]) on ask.libreoffice.org discusses this, and three possible solutions are given: * This add-on (see URL [2]), but it seems that it is no longer maintained, and may not work for the latest versions of LO. I haven't tried it, so you'll have to see for yourself. * There is also mention of this Microsoft article that gives some macro code for Excel (see URL [3]), which presumably could be converted to work with Calc. * Some code is also given, presumably for LO Basic, but it seems to be for Indian currency. This could probably also be converted to your currency of choice. [1]http://ask.libreoffice.org/en/question/1194/convert-numbers-to-english-words/ [2]http://extensions.libreoffice.org/extension-center/numbertext-1 [3]http://support.microsoft.com/kb/213360 So in short there seems to be no easy way of doing this. You might find that the extension works for you, or you might have to write a macro to do this, using one of the two examples as a starting point. Hope this helped. Paul On Fri, 21 Feb 2014 06:13:58 -0500 "Dennis Regan" <[email protected]> wrote: > FOR CLARITY TO MY SPREADSHEET READERS I WOULD LIKE NUMBERS TO READ IN > TWO DIFFERENT WAYS: > > +) $2,000 > > +) TWO THOUSAND DOLLARS > > IS THIS POSSIBLE? > > -----Original Message----- > From: Paul > Sent: Friday, February 21, 2014 6:04 AM > To: [email protected] > Cc: [email protected] > Subject: Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN > LibreOffice CALC TO TEXT IN LibreOffice CALC? > > I think the formula you want is "TEXT". > > I'm not too sure on the format parameter to this function, haven't > checked that, but for me a format string of "#.##" worked fine for a > number with a decimal place. You should be able to find further > details of the format string in the help or online. > > So, for example, I put the number "1234.5" in cell A1, then in cell B1 > I put the formula '=TEXT(A1,"#.##")', and now cell B1 holds the text > string "1234.5". > > I hope this is what you were looking for. > > Paul > > > > On Fri, 21 Feb 2014 02:55:53 -0500 > "Dennis Regan" <[email protected]> wrote: > > > MY EMAIL ADDRESS IS: [email protected] > > > > DEAR SIR OR MS., > > > > MY NAME IS DENNIS REGAN AND I HAVE A QUESTION FOR YOU THAT I > > COULDN’T FIND THE ANSWER TO ONLINE OR IN LibreOffice Calc Help. > > > > +) HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN > > LibreOffice CALC? > > > > THERE ARE AN AWFUL LOT OF FORMULAS AND SYNTAX FOR EXCEL ONLINE FOR > > THIS BUT NONE WORK IN LibreOffice Calc. > > > > PLEASE ADVISE AS SOON AS POSSIBLE USING THIS EMAIL OR THE EMAIL > > ADDRESS FOUND ABOVE. THANK YOU! > > > > Very Sincerely, > > > > Dennis Regan > > > -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
