Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


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.