Hi :) It's an unusual problem that looks a lot like a fairly frequently asked question. Your question has an extra twist which we didn't notice earlier.
I am not sure if there is an easy way to convert numbers to words. ie 2,000 to "Two thousand" So far people have been talking about how to make the numbers look like numbers still but just be unable to perform calculations using them. It's good for telephone numbers, zip-codes and that sort of thing. There might be an "Extension" (what other people call "Add-ons" or "Plug-ins") to do that in LibreOffice itself or there might be a separate "app" (or program) that can do this outside of LibreOffice. Our Extensions page is here; http://www.libreoffice.org/features/extensions/ Most are written by 3rd parties but some are very popular. There are also Extensions written for OpenOffice which might still work with LO or it might be easy to contact their devs to ask them if they could update it for LO. Sorry this isn't very helpful! Apols and regards from Tom :) On 21 February 2014 13:28, C <[email protected]> wrote: > Hi there! > > You can convert a number in text if you place an apostrophe sign before your > number (e.g. '123). Also, you can select desired cells and then use Format > menu>Cells....>Numbers tab>Category>Text >OK. > > Cristi > > > On 21/02/2014 09:55, Dennis Regan 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 -- 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
