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" <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
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: users+unsubscribe@global.libreoffice.org
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
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: 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.