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
I hope this is what you were looking for.
On Fri, 21 Feb 2014 02:55:53 -0500
"Dennis Regan" <DennisPRegan2@hotmail.com> wrote:
MY EMAIL ADDRESS IS: DennisPRegan2@hotmail.com
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
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!
To unsubscribe e-mail to: email@example.com
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy