Ask Your Question

Peter B's profile - activity

2019-03-28 15:47:56 +0100 received badge  Notable Question (source)
2019-03-28 07:52:43 +0100 received badge  Popular Question (source)
2019-03-28 01:39:01 +0100 commented answer =concatenate function won't work

Got it. It works now. Thank you very, very much. I had no idea. Had never run into that before... Peter

2019-03-28 01:04:22 +0100 commented answer =concatenate function won't work

I don't understand what a "(fake) Numbers format code @" is. How do I determine this and what should I format the cell (

2019-03-28 00:36:52 +0100 edited question =concatenate function won't work

=concatenate function won't work I have a simple spreadsheet where I want to use the =concatenate function to combine th

2019-03-28 00:31:37 +0100 asked a question =concatenate function won't work

=concatenate function won't work I have a simple spreadsheet where I want to use the =concatenate function to combine th

2015-02-10 04:29:25 +0100 received badge  Famous Question (source)
2015-02-10 04:29:25 +0100 received badge  Notable Question (source)
2014-09-06 11:59:22 +0100 received badge  Popular Question (source)
2014-09-05 22:59:05 +0100 commented answer How do you convert numbers to text?

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. :-)

2014-09-05 22:31:46 +0100 answered a question How do you convert numbers to text?

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. :-)

2014-09-05 21:01:36 +0100 asked a question How do you convert numbers to text?
  1. 4.2.6.3, 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