First time here? Check out the FAQ!
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?
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 |