https://neowiki.neooffice.org/index.php?title=Converting_a_Text_String_to_a_Number_in_Calc&action=history&feed=atomConverting a Text String to a Number in Calc - Revision history2024-03-29T06:51:51ZRevision history for this page on the wikiMediaWiki 1.10.1https://neowiki.neooffice.org/index.php?title=Converting_a_Text_String_to_a_Number_in_Calc&diff=18007&oldid=prevPluby: Revert most of last change as the change solves a different issue than the original steps2017-08-21T00:59:40Z<p>Revert most of last change as the change solves a different issue than the original steps</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 00:59, 21 August 2017</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 8:</strong></td>
<td colspan="2" align="left"><strong>Line 8:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Using the Find & Replace Function==</td><td> </td><td style="background: #eee; font-size: smaller;">==Using the Find & Replace Function==</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Select the cell range which contains text strings.</td><td> </td><td style="background: #eee; font-size: smaller;">*Select the cell range which contains text strings.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*Choose the {{menu|Edit}} menu then the {{menu|Find & Replace…}} <del style="color: red; font-weight: bold; text-decoration: none;">sub-menu</del>.</td><td>+</td><td style="background: #cfc; font-size: smaller;">*Choose the {{menu|Edit}} menu then the {{menu|Find & Replace…}} <ins style="color: red; font-weight: bold; text-decoration: none;">submenu</ins>.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*In the {{window|Find & Replace}} window, enter "'''^[<del style="color: red; font-weight: bold; text-decoration: none;">^</del>0-9\-]'''" (without quotes) in the {{section|Search <del style="color: red; font-weight: bold; text-decoration: none;">For</del>}} field.</td><td>+</td><td style="background: #cfc; font-size: smaller;">*In the {{window|Find & Replace}} window, enter "'''^[0-9\-]'''" (without quotes) in the {{section|Search <ins style="color: red; font-weight: bold; text-decoration: none;">for</ins>}} field.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*<del style="color: red; font-weight: bold; text-decoration: none;">Set </del>the {{section|Replace <del style="color: red; font-weight: bold; text-decoration: none;">With</del>}} field <del style="color: red; font-weight: bold; text-decoration: none;">to empty</del>.</td><td>+</td><td style="background: #cfc; font-size: smaller;">*<ins style="color: red; font-weight: bold; text-decoration: none;">In </ins>the <ins style="color: red; font-weight: bold; text-decoration: none;"> </ins>{{section|Replace <ins style="color: red; font-weight: bold; text-decoration: none;">with</ins>}} field<ins style="color: red; font-weight: bold; text-decoration: none;">, enter "'''&'''" (without quotes)</ins>.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Click {{button|Other options}} or {{button|More options}} button.</td><td> </td><td style="background: #eee; font-size: smaller;">*Click {{button|Other options}} or {{button|More options}} button.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Check the {{prefName|Regular expressions}} checkbox.</td><td> </td><td style="background: #eee; font-size: smaller;">*Check the {{prefName|Regular expressions}} checkbox.</td></tr>
</table>Plubyhttps://neowiki.neooffice.org/index.php?title=Converting_a_Text_String_to_a_Number_in_Calc&diff=18004&oldid=prevPluby: /* Using the Find & Replace Function */ Update steps to work with NeoOffice 20172017-08-20T21:27:45Z<p><span class="autocomment">Using the Find & Replace Function -</span> Update steps to work with NeoOffice 2017</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 21:27, 20 August 2017</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 9:</strong></td>
<td colspan="2" align="left"><strong>Line 9:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Select the cell range which contains text strings.</td><td> </td><td style="background: #eee; font-size: smaller;">*Select the cell range which contains text strings.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Choose the {{menu|Edit}} menu then the {{menu|Find & Replace…}} sub-menu.</td><td> </td><td style="background: #eee; font-size: smaller;">*Choose the {{menu|Edit}} menu then the {{menu|Find & Replace…}} sub-menu.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*In the {{window|Find & Replace}} window, enter "'''^[0-9\-]'''" (without quotes) in the {{section|Search <del style="color: red; font-weight: bold; text-decoration: none;">for</del>}} field.</td><td>+</td><td style="background: #cfc; font-size: smaller;">*In the {{window|Find & Replace}} window, enter "'''^[<ins style="color: red; font-weight: bold; text-decoration: none;">^</ins>0-9\-]'''" (without quotes) in the {{section|Search <ins style="color: red; font-weight: bold; text-decoration: none;">For</ins>}} field.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*<del style="color: red; font-weight: bold; text-decoration: none;">In </del>the <del style="color: red; font-weight: bold; text-decoration: none;"> </del>{{section|Replace <del style="color: red; font-weight: bold; text-decoration: none;">with</del>}} field<del style="color: red; font-weight: bold; text-decoration: none;">, enter "'''&'''" (without quotes)</del>.</td><td>+</td><td style="background: #cfc; font-size: smaller;">*<ins style="color: red; font-weight: bold; text-decoration: none;">Set </ins>the {{section|Replace <ins style="color: red; font-weight: bold; text-decoration: none;">With</ins>}} field <ins style="color: red; font-weight: bold; text-decoration: none;">to empty</ins>.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*Click {{button|More options}}.</td><td>+</td><td style="background: #cfc; font-size: smaller;">*Click <ins style="color: red; font-weight: bold; text-decoration: none;">{{button|Other options}} or </ins>{{button|More options}} <ins style="color: red; font-weight: bold; text-decoration: none;">button</ins>.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*Check the {{prefName|Regular expressions}} <del style="color: red; font-weight: bold; text-decoration: none;">case</del>.</td><td>+</td><td style="background: #cfc; font-size: smaller;">*Check the {{prefName|Regular expressions}} <ins style="color: red; font-weight: bold; text-decoration: none;">checkbox</ins>.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*Click {{button|Replace <del style="color: red; font-weight: bold; text-decoration: none;">all</del>}}.</td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">*Set the {{prefName|Search in}} listbox to {{button|Values}}</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">*Click {{button|Replace <ins style="color: red; font-weight: bold; text-decoration: none;">All</ins>}}.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Using the VALUE Function==</td><td> </td><td style="background: #eee; font-size: smaller;">==Using the VALUE Function==</td></tr>
</table>Plubyhttps://neowiki.neooffice.org/index.php?title=Converting_a_Text_String_to_a_Number_in_Calc&diff=17418&oldid=prevPluby: /* Using the Find & Replace Function */ Add "\-" to "Search for" to convert negative numbers2015-08-31T14:17:31Z<p><span class="autocomment">Using the Find & Replace Function -</span> Add "\-" to "Search for" to convert negative numbers</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 14:17, 31 August 2015</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 9:</strong></td>
<td colspan="2" align="left"><strong>Line 9:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Select the cell range which contains text strings.</td><td> </td><td style="background: #eee; font-size: smaller;">*Select the cell range which contains text strings.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Choose the {{menu|Edit}} menu then the {{menu|Find & Replace…}} sub-menu.</td><td> </td><td style="background: #eee; font-size: smaller;">*Choose the {{menu|Edit}} menu then the {{menu|Find & Replace…}} sub-menu.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*In the {{window|Find & Replace}} window, enter "'''^[0-9]'''" (without quotes) in the {{section|Search for}} field.</td><td>+</td><td style="background: #cfc; font-size: smaller;">*In the {{window|Find & Replace}} window, enter "'''^[0-9<ins style="color: red; font-weight: bold; text-decoration: none;">\-</ins>]'''" (without quotes) in the {{section|Search for}} field.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*In the {{section|Replace with}} field, enter "'''&'''" (without quotes).</td><td> </td><td style="background: #eee; font-size: smaller;">*In the {{section|Replace with}} field, enter "'''&'''" (without quotes).</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Click {{button|More options}}.</td><td> </td><td style="background: #eee; font-size: smaller;">*Click {{button|More options}}.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Check the {{prefName|Regular expressions}} case.</td><td> </td><td style="background: #eee; font-size: smaller;">*Check the {{prefName|Regular expressions}} case.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Click {{button|Replace all}}.</td><td> </td><td style="background: #eee; font-size: smaller;">*Click {{button|Replace all}}.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"></td><td colspan="2"> </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Using the VALUE Function==</td><td> </td><td style="background: #eee; font-size: smaller;">==Using the VALUE Function==</td></tr>
</table>Plubyhttps://neowiki.neooffice.org/index.php?title=Converting_a_Text_String_to_a_Number_in_Calc&diff=10699&oldid=prevJgd at 12:07, 13 May 20072007-05-13T12:07:06Z<p></p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 12:07, 13 May 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 3:</strong></td>
<td colspan="2" align="left"><strong>Line 3:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">In those cells, numbers appear normally, but are aligned to the left like character strings. If you click in a cell which contains a number, for instance 23, you will see '23 in the formula bar.</td><td> </td><td style="background: #eee; font-size: smaller;">In those cells, numbers appear normally, but are aligned to the left like character strings. If you click in a cell which contains a number, for instance 23, you will see '23 in the formula bar.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">In order to convert those text strings to ''number'' format, you have two possibilities</td><td> </td><td style="background: #eee; font-size: smaller;">In order to convert those text strings to ''number'' format, you have two possibilities</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"># Use the '''Find& Replace''' function</td><td>+</td><td style="background: #cfc; font-size: smaller;"># Use the '''Find & Replace''' function</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"># Use the '''VALUE''' function. </td><td> </td><td style="background: #eee; font-size: smaller;"># Use the '''VALUE''' function. </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
</table>Jgdhttps://neowiki.neooffice.org/index.php?title=Converting_a_Text_String_to_a_Number_in_Calc&diff=10655&oldid=prevJgd: add using the Find & Replace function2007-05-08T13:06:16Z<p>add using the Find & Replace function</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 13:06, 8 May 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 2:</strong></td>
<td colspan="2" align="left"><strong>Line 2:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">In a Calc document, sometimes numbers are entered in ''text'' format, for example when the tables come from converted files (such as converted .pdf files).</td><td> </td><td style="background: #eee; font-size: smaller;">In a Calc document, sometimes numbers are entered in ''text'' format, for example when the tables come from converted files (such as converted .pdf files).</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">In those cells, numbers appear normally, but are aligned to the left like character strings. If you click in a cell which contains a number, for instance 23, you will see '23 in the formula bar.</td><td> </td><td style="background: #eee; font-size: smaller;">In those cells, numbers appear normally, but are aligned to the left like character strings. If you click in a cell which contains a number, for instance 23, you will see '23 in the formula bar.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">In order to convert those text strings to ''number'' format, you <del style="color: red; font-weight: bold; text-decoration: none;">can use </del>the '''VALUE''' function.</td><td>+</td><td style="background: #cfc; font-size: smaller;">In order to convert those text strings to ''number'' format, you <ins style="color: red; font-weight: bold; text-decoration: none;">have two possibilities</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;"># Use the '''Find& Replace''' function</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;"># Use </ins>the '''VALUE''' function. </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">==<del style="color: red; font-weight: bold; text-decoration: none;">Converting a </del>''<del style="color: red; font-weight: bold; text-decoration: none;">text string</del>'' <del style="color: red; font-weight: bold; text-decoration: none;">to a </del>''<del style="color: red; font-weight: bold; text-decoration: none;">number</del>''==</td><td>+</td><td style="background: #cfc; font-size: smaller;">==<ins style="color: red; font-weight: bold; text-decoration: none;">Using the Find & Replace Function==</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">*Select the cell range which contains text strings.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">*Choose the {{menu|Edit}} menu then the {{menu|Find & Replace…}} sub-menu.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">*In the {{window|Find & Replace}} window, enter "</ins>''<ins style="color: red; font-weight: bold; text-decoration: none;">'^[0-9]'''" (without quotes) in the {{section|Search for}} field.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">*In the {{section|Replace with}} field, enter "</ins>'''<ins style="color: red; font-weight: bold; text-decoration: none;">&</ins>'''<ins style="color: red; font-weight: bold; text-decoration: none;">" (without quotes).</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">*Click {{button|More options}}.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">*Check the {{prefName|Regular expressions}} case.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">*Click {{button|Replace all}}.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"> </td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"> </td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">==Using the VALUE Function</ins>==</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Let us assume that the cells A1, A2, A3 contain 23, 12, 36 in ''text'' format. We are going to display the same values in the cells B1, B2, B3, but in ''number'' format.</td><td> </td><td style="background: #eee; font-size: smaller;">Let us assume that the cells A1, A2, A3 contain 23, 12, 36 in ''text'' format. We are going to display the same values in the cells B1, B2, B3, but in ''number'' format.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">* Click in the cell B1</td><td> </td><td style="background: #eee; font-size: smaller;">* Click in the cell B1</td></tr>
</table>Jgdhttps://neowiki.neooffice.org/index.php?title=Converting_a_Text_String_to_a_Number_in_Calc&diff=9864&oldid=prevSamwise: use templates2007-03-24T15:49:57Z<p>use templates</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 15:49, 24 March 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 8:</strong></td>
<td colspan="2" align="left"><strong>Line 8:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">* Click in the cell B1</td><td> </td><td style="background: #eee; font-size: smaller;">* Click in the cell B1</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">* Click on the "'''='''" sign on the left side of the formula bar.</td><td> </td><td style="background: #eee; font-size: smaller;">* Click on the "'''='''" sign on the left side of the formula bar.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">* type '''VALUE''' in the input line, then press <del style="color: red; font-weight: bold; text-decoration: none;">'''</del>Enter<del style="color: red; font-weight: bold; text-decoration: none;">''' </del>or <del style="color: red; font-weight: bold; text-decoration: none;">'''</del>Return<del style="color: red; font-weight: bold; text-decoration: none;">'''</del>. </td><td>+</td><td style="background: #cfc; font-size: smaller;">* type '''VALUE''' in the input line, then press <ins style="color: red; font-weight: bold; text-decoration: none;">{{key|</ins>Enter<ins style="color: red; font-weight: bold; text-decoration: none;">}} </ins>or <ins style="color: red; font-weight: bold; text-decoration: none;">{{key|</ins>Return<ins style="color: red; font-weight: bold; text-decoration: none;">}}</ins>. </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">** You can also enter that function by clicking on the formula icon on the left side of the Σ sign. In the {{window|Function Wizard}} dialogue that opens, click on the {{section|Functions}} tab, then the {{prefName|Text}} category and select '''VALUE'''.</td><td> </td><td style="background: #eee; font-size: smaller;">** You can also enter that function by clicking on the formula icon on the left side of the Σ sign. In the {{window|Function Wizard}} dialogue that opens, click on the {{section|Functions}} tab, then the {{prefName|Text}} category and select '''VALUE'''.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">** Click {{button|Next}}.</td><td> </td><td style="background: #eee; font-size: smaller;">** Click {{button|Next}}.</td></tr>
</table>Samwisehttps://neowiki.neooffice.org/index.php?title=Converting_a_Text_String_to_a_Number_in_Calc&diff=9858&oldid=prevSamwise: correct instructions2007-03-24T15:36:53Z<p>correct instructions</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 15:36, 24 March 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 8:</strong></td>
<td colspan="2" align="left"><strong>Line 8:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">* Click in the cell B1</td><td> </td><td style="background: #eee; font-size: smaller;">* Click in the cell B1</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">* Click on the "'''='''" sign on the left side of the formula bar.</td><td> </td><td style="background: #eee; font-size: smaller;">* Click on the "'''='''" sign on the left side of the formula bar.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">* type '''VALUE<del style="color: red; font-weight: bold; text-decoration: none;">(A1)</del>''' in the input line. </td><td>+</td><td style="background: #cfc; font-size: smaller;">* type '''VALUE''' in the input line<ins style="color: red; font-weight: bold; text-decoration: none;">, then press '''Enter''' or '''Return'''</ins>. </td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">** You can enter that function by clicking on the formula icon on the left side of the Σ sign. In the {{window|Function Wizard}} dialogue that opens, click on the {{section|Functions}} tab, then the {{prefName|Text}} category and select '''VALUE'''.</td><td>+</td><td style="background: #cfc; font-size: smaller;">** You can <ins style="color: red; font-weight: bold; text-decoration: none;">also </ins>enter that function by clicking on the formula icon on the left side of the Σ sign. In the {{window|Function Wizard}} dialogue that opens, click on the {{section|Functions}} tab, then the {{prefName|Text}} category and select '''VALUE'''.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">** Click {{button|Next}}.</td><td> </td><td style="background: #eee; font-size: smaller;">** Click {{button|Next}}.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">* Click in the cell A1. Now it is highlighted with red <!--isn't it blue?--> borders. </td><td> </td><td style="background: #eee; font-size: smaller;">* Click in the cell A1. Now it is highlighted with red <!--isn't it blue?--> borders. </td></tr>
</table>Samwisehttps://neowiki.neooffice.org/index.php?title=Converting_a_Text_String_to_a_Number_in_Calc&diff=9844&oldid=prevValterb: botlangbar -> IT2007-03-24T15:04:48Z<p>botlangbar -> IT</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 15:04, 24 March 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 36:</strong></td>
<td colspan="2" align="left"><strong>Line 36:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">A new sheet is added in which you can delete one of the two columns A or B. Now, both of them contain ''numbers''.</td><td> </td><td style="background: #eee; font-size: smaller;">A new sheet is added in which you can delete one of the two columns A or B. Now, both of them contain ''numbers''.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">{{botlangbarEN|[[Fr:Convertir une Chaîne de Texte en Nombre dans Calc|Français]]}}</td><td>+</td><td style="background: #cfc; font-size: smaller;">{{botlangbarEN|[[Fr:Convertir une Chaîne de Texte en Nombre dans Calc|Français<ins style="color: red; font-weight: bold; text-decoration: none;">]] [[It:Convertire_una_stringa_di_testo_in_un_numero_in_Calc|Italiano</ins>]]}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]]</td><td> </td><td style="background: #eee; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]]</td></tr>
</table>Valterbhttps://neowiki.neooffice.org/index.php?title=Converting_a_Text_String_to_a_Number_in_Calc&diff=9841&oldid=prevSamwise: a red rectangle > red borders2007-03-24T14:11:29Z<p>a red rectangle > red borders</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 14:11, 24 March 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 11:</strong></td>
<td colspan="2" align="left"><strong>Line 11:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">** You can enter that function by clicking on the formula icon on the left side of the Σ sign. In the {{window|Function Wizard}} dialogue that opens, click on the {{section|Functions}} tab, then the {{prefName|Text}} category and select '''VALUE'''.</td><td> </td><td style="background: #eee; font-size: smaller;">** You can enter that function by clicking on the formula icon on the left side of the Σ sign. In the {{window|Function Wizard}} dialogue that opens, click on the {{section|Functions}} tab, then the {{prefName|Text}} category and select '''VALUE'''.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">** Click {{button|Next}}.</td><td> </td><td style="background: #eee; font-size: smaller;">** Click {{button|Next}}.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">* Click in the cell A1. Now it is highlighted with <del style="color: red; font-weight: bold; text-decoration: none;">a </del>red <!--isn't it blue?--> <del style="color: red; font-weight: bold; text-decoration: none;">rectangle</del>. </td><td>+</td><td style="background: #cfc; font-size: smaller;">* Click in the cell A1. Now it is highlighted with red <!--isn't it blue?--> <ins style="color: red; font-weight: bold; text-decoration: none;">borders</ins>. </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">* Press {{key|Enter}} or {{key|Return}}. The number 23 is aligned to the right in the cell B1.</td><td> </td><td style="background: #eee; font-size: smaller;">* Press {{key|Enter}} or {{key|Return}}. The number 23 is aligned to the right in the cell B1.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">* Then select the three cells B1 to B3, by clicking in the cell B1 then dragging the cursor to the cell B3, or by clicking in the cell B1 then holding the {{key|Shift}} key down while clicking in the cell B3.</td><td> </td><td style="background: #eee; font-size: smaller;">* Then select the three cells B1 to B3, by clicking in the cell B1 then dragging the cursor to the cell B3, or by clicking in the cell B1 then holding the {{key|Shift}} key down while clicking in the cell B3.</td></tr>
</table>Samwisehttps://neowiki.neooffice.org/index.php?title=Converting_a_Text_String_to_a_Number_in_Calc&diff=9840&oldid=prevSamwise: Polish2007-03-24T13:36:09Z<p>Polish</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 13:36, 24 March 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{Fixme}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{Fixme}}</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">In a Calc document, sometimes <del style="color: red; font-weight: bold; text-decoration: none;">it happens that some cells formatted </del>in ''<del style="color: red; font-weight: bold; text-decoration: none;">Text</del>'' format <del style="color: red; font-weight: bold; text-decoration: none;">contain ''Numbers''</del>, for example when the tables come from converted files<del style="color: red; font-weight: bold; text-decoration: none;">, </del>(such as converted .pdf files).</td><td>+</td><td style="background: #cfc; font-size: smaller;">In a Calc document, sometimes <ins style="color: red; font-weight: bold; text-decoration: none;">numbers are entered </ins>in ''<ins style="color: red; font-weight: bold; text-decoration: none;">text</ins>'' format, for example when the tables come from converted files (such as converted .pdf files).</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">In those cells, <del style="color: red; font-weight: bold; text-decoration: none;">the </del>numbers appear normally, but <del style="color: red; font-weight: bold; text-decoration: none;">they </del>are aligned to the left like strings <del style="color: red; font-weight: bold; text-decoration: none;">of characters</del>. If you click in a cell which contains <del style="color: red; font-weight: bold; text-decoration: none;">such </del>a number, for instance 23, you will see '23 in the formula bar.</td><td>+</td><td style="background: #cfc; font-size: smaller;">In those cells, numbers appear normally, but are aligned to the left like <ins style="color: red; font-weight: bold; text-decoration: none;">character </ins>strings. If you click in a cell which contains a number, for instance 23, you will see '23 in the formula bar.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">In order to convert those <del style="color: red; font-weight: bold; text-decoration: none;">''</del>text strings<del style="color: red; font-weight: bold; text-decoration: none;">'' </del> to ''<del style="color: red; font-weight: bold; text-decoration: none;">numbers</del>'', you <del style="color: red; font-weight: bold; text-decoration: none;">have a function available: </del>the '''VALUE''' function.</td><td>+</td><td style="background: #cfc; font-size: smaller;">In order to convert those text strings to ''<ins style="color: red; font-weight: bold; text-decoration: none;">number</ins>'' <ins style="color: red; font-weight: bold; text-decoration: none;">format</ins>, you <ins style="color: red; font-weight: bold; text-decoration: none;">can use </ins>the '''VALUE''' function.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Converting a ''text string'' to a ''number''==</td><td> </td><td style="background: #eee; font-size: smaller;">==Converting a ''text string'' to a ''number''==</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Let us assume that the cells A1, A2, A3 contain 23, 12, 36 in ''text'' format. We are going to display the same values in the cells B1, B2, B3, but in ''number'' format.</td><td> </td><td style="background: #eee; font-size: smaller;">Let us assume that the cells A1, A2, A3 contain 23, 12, 36 in ''text'' format. We are going to display the same values in the cells B1, B2, B3, but in ''number'' format.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">* Click in the cell B1</td><td> </td><td style="background: #eee; font-size: smaller;">* Click in the cell B1</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">* Click the <del style="color: red; font-weight: bold; text-decoration: none;">minus sign </del>"'''='''" on the left side of the formula bar.</td><td>+</td><td style="background: #cfc; font-size: smaller;">* Click <ins style="color: red; font-weight: bold; text-decoration: none;">on </ins>the "'''='''" <ins style="color: red; font-weight: bold; text-decoration: none;">sign </ins>on the left side of the formula bar.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">* type '''VALUE''' in the input line. </td><td>+</td><td style="background: #cfc; font-size: smaller;">* type '''VALUE<ins style="color: red; font-weight: bold; text-decoration: none;">(A1)</ins>''' in the input line. </td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">** You can <del style="color: red; font-weight: bold; text-decoration: none;">find </del>that function by clicking the formula icon on the left side of the Σ sign. In the {{window|Function Wizard}} dialogue that opens, click the {{section|Functions}} tab, then the {{prefName|Text}} category and select '''VALUE'''.</td><td>+</td><td style="background: #cfc; font-size: smaller;">** You can <ins style="color: red; font-weight: bold; text-decoration: none;">enter </ins>that function by clicking <ins style="color: red; font-weight: bold; text-decoration: none;">on </ins>the formula icon on the left side of the Σ sign. In the {{window|Function Wizard}} dialogue that opens, click <ins style="color: red; font-weight: bold; text-decoration: none;">on </ins>the {{section|Functions}} tab, then the {{prefName|Text}} category and select '''VALUE'''.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">** Click {{button|Next}}.</td><td> </td><td style="background: #eee; font-size: smaller;">** Click {{button|Next}}.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">* Click in the cell A1. Now it is <del style="color: red; font-weight: bold; text-decoration: none;"> bordered </del>with a red rectangle. </td><td>+</td><td style="background: #cfc; font-size: smaller;">* Click in the cell A1. Now it is <ins style="color: red; font-weight: bold; text-decoration: none;">highlighted </ins>with a red <ins style="color: red; font-weight: bold; text-decoration: none;"><!--isn't it blue?--> </ins>rectangle. </td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">* Press {{key|Enter}} or {{key|Return}}. The number 23 <del style="color: red; font-weight: bold; text-decoration: none;">appears </del>aligned to the right in the cell B1.</td><td>+</td><td style="background: #cfc; font-size: smaller;">* Press {{key|Enter}} or {{key|Return}}. The number 23 <ins style="color: red; font-weight: bold; text-decoration: none;">is </ins>aligned to the right in the cell B1.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">* Then select the three cells B1 to B3, by clicking the cell B1 then dragging the cursor to the cell B3, or by clicking the cell B1 then<del style="color: red; font-weight: bold; text-decoration: none;">, pressing </del>the {{key|Shift}} key<del style="color: red; font-weight: bold; text-decoration: none;">, </del>clicking the cell B3.</td><td>+</td><td style="background: #cfc; font-size: smaller;">* Then select the three cells B1 to B3, by clicking <ins style="color: red; font-weight: bold; text-decoration: none;">in </ins>the cell B1 then dragging the cursor to the cell B3, or by clicking <ins style="color: red; font-weight: bold; text-decoration: none;">in </ins>the cell B1 then <ins style="color: red; font-weight: bold; text-decoration: none;">holding </ins>the {{key|Shift}} key <ins style="color: red; font-weight: bold; text-decoration: none;">down while </ins>clicking <ins style="color: red; font-weight: bold; text-decoration: none;">in </ins>the cell B3.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">* Go to the {{menu|Edit}} menu, then the {{menu|Fill}} <del style="color: red; font-weight: bold; text-decoration: none;">sub-menu </del>and select {{menu|Down}}.<br/></td><td>+</td><td style="background: #cfc; font-size: smaller;">* Go to the {{menu|Edit}} menu, then the {{menu|Fill}} <ins style="color: red; font-weight: bold; text-decoration: none;">submenu </ins>and select {{menu|Down}}.<br/></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">The three cells B1, B2, B3 now contain <del style="color: red; font-weight: bold; text-decoration: none;">the ''numbers'' </del>23, 12 and 36.<br/></td><td>+</td><td style="background: #cfc; font-size: smaller;">The three cells B1, B2, B3 now contain 23, 12 and 36 <ins style="color: red; font-weight: bold; text-decoration: none;">in ''number'' format</ins>.<br/></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[[Image:Number.png|Converting a Text String to a Number]]</td><td> </td><td style="background: #eee; font-size: smaller;">[[Image:Number.png|Converting a Text String to a Number]]</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">==Removing the cells which contain <del style="color: red; font-weight: bold; text-decoration: none;">''</del>text <del style="color: red; font-weight: bold; text-decoration: none;">string''</del>==</td><td>+</td><td style="background: #cfc; font-size: smaller;">==Removing the cells which contain <ins style="color: red; font-weight: bold; text-decoration: none;">the </ins>text <ins style="color: red; font-weight: bold; text-decoration: none;">strings</ins>==</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Now, you may want to delete the cells A1 to A3. Unfortunately, if you delete them the cells B1, B2 and B3 will contain only 0, since it is the value that the '''VALUE''' function assigns to an empty string.<br/></td><td> </td><td style="background: #eee; font-size: smaller;">Now, you may want to delete the cells A1 to A3. Unfortunately, if you delete them the cells B1, B2 and B3 will contain only 0, since it is the value that the '''VALUE''' function assigns to an empty string.<br/></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">In order to solve that <del style="color: red; font-weight: bold; text-decoration: none;">ptoblem</del>, you can simply hide the column A by right clicking (or Ctrl-<del style="color: red; font-weight: bold; text-decoration: none;">click</del>) <del style="color: red; font-weight: bold; text-decoration: none;">the header of </del>the column then selecting {{prefName|Hide}}. <br/></td><td>+</td><td style="background: #cfc; font-size: smaller;">In order to solve that <ins style="color: red; font-weight: bold; text-decoration: none;">problem</ins>, you can simply hide the column A by right<ins style="color: red; font-weight: bold; text-decoration: none;">-</ins>clicking (or Ctrl-<ins style="color: red; font-weight: bold; text-decoration: none;">clicking</ins>) <ins style="color: red; font-weight: bold; text-decoration: none;">on </ins>the column <ins style="color: red; font-weight: bold; text-decoration: none;">header </ins>then selecting {{prefName|Hide}}. <br/></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">Another method, more complex, <del style="color: red; font-weight: bold; text-decoration: none;">allows </del>you to really delete it.</td><td>+</td><td style="background: #cfc; font-size: smaller;">Another method, more complex, <ins style="color: red; font-weight: bold; text-decoration: none;">will allow </ins>you to really delete it.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"># Export the sheet in <tt><del style="color: red; font-weight: bold; text-decoration: none;">Texte </del>CSV</tt> format:</td><td>+</td><td style="background: #cfc; font-size: smaller;"># Export the sheet in <tt><ins style="color: red; font-weight: bold; text-decoration: none;">Text </ins>CSV</tt> format:</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#* In the {{menu|File}} menu choose {{menu|Save As…}}.</td><td> </td><td style="background: #eee; font-size: smaller;">#* In the {{menu|File}} menu choose {{menu|Save As…}}.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#* In the {{window|Save}} window and in the {{section|File type}} drop down menu, choose {{prefName|Text CSV(.csv)}} and check {{prefName|Edit filter settings}}. </td><td>+</td><td style="background: #cfc; font-size: smaller;">#* In the {{window|Save}} window and in the {{section|File type}} drop down menu, choose {{prefName|Text CSV (.csv)}} and check {{prefName|Edit filter settings}}. </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#* Click {{button|Save}}.</td><td> </td><td style="background: #eee; font-size: smaller;">#* Click {{button|Save}}.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#* In the dialogue asking if you want to save the document in the <tt>.csv</tt> format, click {{button|Yes}}.</td><td> </td><td style="background: #eee; font-size: smaller;">#* In the dialogue asking if you want to save the document in the <tt>.csv</tt> format, click {{button|Yes}}.</td></tr>
<tr><td colspan="2" align="left"><strong>Line 30:</strong></td>
<td colspan="2" align="left"><strong>Line 30:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"># Import the <tt>.csv</tt> file in a spreadsheet and remove the column A:</td><td> </td><td style="background: #eee; font-size: smaller;"># Import the <tt>.csv</tt> file in a spreadsheet and remove the column A:</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#* Open a Calc document (which can be the same as the one from which you exported a sheet in <tt>.csv</tt> format).</td><td> </td><td style="background: #eee; font-size: smaller;">#* Open a Calc document (which can be the same as the one from which you exported a sheet in <tt>.csv</tt> format).</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#*Go to the {{menu|Insert}} menu and select the {{menu|Sheet From File…}} <del style="color: red; font-weight: bold; text-decoration: none;">sub-menu</del>.</td><td>+</td><td style="background: #cfc; font-size: smaller;">#*Go to the {{menu|Insert}} menu and select the {{menu|Sheet From File…}} <ins style="color: red; font-weight: bold; text-decoration: none;">submenu</ins>.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#* Choose the <tt>.csv</tt> file you created before.</td><td> </td><td style="background: #eee; font-size: smaller;">#* Choose the <tt>.csv</tt> file you created before.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#* In the {{window|Text Import}} dialogue, be sure that the {{prefName|Tab}} option is selected in the {{section|Separator options}} section.</td><td> </td><td style="background: #eee; font-size: smaller;">#* In the {{window|Text Import}} dialogue, be sure that the {{prefName|Tab}} option is selected in the {{section|Separator options}} section.</td></tr>
</table>Samwise