Ask Your Question

How do you convert numbers to text? [closed]

asked 2014-09-05 21:01:36 +0100

Peter B gravatar image

updated 2016-03-03 16:30:03 +0100

Alex Kemp gravatar image
  1., English, Calc
  2. W7 of Windows (current fixes applied)

In a spreadsheet that someone else created (Lotus Symphony converted to Lotus 123 converted to .ODS) there is a column with note references in it that are numeric in some cells and alphabetic in the others. When I sort the 1300 rows on this column, the numbers come first and the alphabetic text numbers come later. I want to convert the numeric numbers to text so that the rows will sort the rows with numeric 2's in the sort column along with the rows with text 2's.

Formatting the numeric cells as text (@) does not change the sorting order to accomplish the above desired result. I have looked and looked and cannot find a way a to convert numbers to text. Hopefully there is a function much like you have for convert each word of text to having the first letter capitalized with the remaining part of the word in lower case.

Is there a way in LibreOffice Calc to convert the numeric numbers to text numbers?

Thank you for time and effort... Peter Bradish, Titusville, FL

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-03 16:30:15.063773


The TEXT function can help you.

MsOffice gravatar imageMsOffice ( 2020-02-15 11:53:38 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2014-09-05 22:15:25 +0100

m.a.riosv gravatar image

Select the column. Menu/Data/Text to column. Click on the column header. In column type select Text. Ok.

image description

edit flag offensive delete link more


Worked like a charm. Thank you very much. I never realized that "Text to column" in the Data drop down menu meant converting from numeric to text. Now all I have left is to strip out leading blanks in some of the other cells in that column and I can send the results on to another researcher. :-)

Peter B gravatar imagePeter B ( 2014-09-05 22:59:05 +0100 )edit

Fabulous answer. I had been tormented by the java.lang.IllegalStateException: Cannot get a text value from a numeric cell for over three days. Thank you

siech gravatar imagesiech ( 2016-07-05 11:31:43 +0100 )edit

Perfect Solution, worked perfectly for me, too!

mtness gravatar imagemtness ( 2018-09-13 10:54:55 +0100 )edit

answered 2014-09-05 22:34:28 +0100

horst gravatar image

Therr is a Calc function NUMBERTEXT downloadable from here.

Give it a try.

edit flag offensive delete link more

Question Tools



Asked: 2014-09-05 21:01:36 +0100

Seen: 21,681 times

Last updated: Sep 05 '14