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" <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