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" <[email protected]> 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
