Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column
At 20:32 12/09/2018 -0400, Art Noname wrote: It's a shame that I can't enter numbers with paste, or paste special. You can. Use Paste Special... if necessary only if your data source is itself a spreadsheet and the values risk arriving with a numerical format associated. The raw data is in html format from the web, so importing it as text might be viable. It is. Indeed, 127.000 and 127.7 are the same number, however, it seems that when I enter 127.700, there should be a way to prevent the spreadsheet from formatting it for its own internal use. I believe this was my original question. And the answer was to format your cell range as text. Last evening, I figured out that I could add .1 to each frequency, which would allow me to search properly, since it's a simple math function, it can be done automatically. So, I enter 127.700 MHz, then add 10Hz to each number. The search function does work this way. Sounds messy and error-prone. I had never thought of formatting the columns BEFORE I pasted the raw data into the spreadsheet!!! That should have been on page one of your spreadsheet beginner's manual. Wasn't it? I have no problem working with text instead of numbers, ... Good. I can do the text part on a separate sheet from the main data. The main sheet is getting more complicated as I add features, so the move to a separate 'text only' sheet might be the answer. You probably don't need to. As suggested earlier, just use VALUE(Xn) where you would otherwise use Xn to extract real numbers from your text values as necessary in formulae. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column
On 12 Sep 2018 at 20:32, Art wrote: Subject:Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column To: users@global.libreoffice.org From: Art Date sent: Wed, 12 Sep 2018 20:32:00 -0400 > On 09/12/2018 12:45 PM, jomali wrote: > > You seem to have a fundamental misunderstanding of how spreadsheets work. > > When you enter a number into a numeric cell, the software converts it into > > an internal format, which it then displays in the format you specify for > > the cell. It does not remember the form in which you entered it. Thus, > > 127.700 and 127.7 are the same number. > > TY all, > > It's a shame that I can't enter numbers with paste, or paste special. > The raw data is in html format from the web, so importing it as text > might be viable. > > Indeed, 127.000 and 127.7 are the same number, however, it seems that > when I enter 127.700, there should be a way to prevent the spreadsheet > from formatting it for its own internal use. I believe this was my > original question::> > > Last evening, I figured out that I could add .1 to each frequency, > which would allow me to search properly, since it's a simple math > function, it can be done automatically. So, I enter 127.700 MHz, then > add 10Hz to each number. The search function does work this way. I'm not > sure how I will proceed, but the input from list members helps a lot! > > I had never thought of formatting the columns BEFORE I pasted the raw > data into the spreadsheet!!! I have no problem working with text instead > of numbers, I can do the text part on a separate sheet from the main > data. The main sheet is getting more complicated as I add features, so > the move to a separate 'text only' sheet might be the answer. > > Again, thank you all! And thanks to those who write the software and run > the mailing list. I'm sure this is never said as often as it should be. Have you selected the column, and set the format for the column (or range) to so the 3 decimal positions you want? If it is set to default, then it will show the number as not showing the trailing zeros. Second, I found that the search works in columns with numbers, but doesn't work if there are formulas in the cells?? The sheet I was using, I had a column where I had copied the values of one column to another column, and the find worked just fine with that one, but later, was trying to do the same on the column with formulas, and it didn't find the match? I also did a search using the formated, and was looking for 4.08, and it found match for 14.08 as well as the 4.08, so it appears to be doing a text match with contains rather than a numeric match when doing the find as formated?? > > Regards, > > Art > > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ ++ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS ROSETTA 65786414.038490 | ABC 16613838.513356 SETI109526605.084600 | EINSTEIN141382979.499240 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column
On 09/12/2018 12:45 PM, jomali wrote: > You seem to have a fundamental misunderstanding of how spreadsheets work. > When you enter a number into a numeric cell, the software converts it into > an internal format, which it then displays in the format you specify for > the cell. It does not remember the form in which you entered it. Thus, > 127.700 and 127.7 are the same number. TY all, It's a shame that I can't enter numbers with paste, or paste special. The raw data is in html format from the web, so importing it as text might be viable. Indeed, 127.000 and 127.7 are the same number, however, it seems that when I enter 127.700, there should be a way to prevent the spreadsheet from formatting it for its own internal use. I believe this was my original question::> Last evening, I figured out that I could add .1 to each frequency, which would allow me to search properly, since it's a simple math function, it can be done automatically. So, I enter 127.700 MHz, then add 10Hz to each number. The search function does work this way. I'm not sure how I will proceed, but the input from list members helps a lot! I had never thought of formatting the columns BEFORE I pasted the raw data into the spreadsheet!!! I have no problem working with text instead of numbers, I can do the text part on a separate sheet from the main data. The main sheet is getting more complicated as I add features, so the move to a separate 'text only' sheet might be the answer. Again, thank you all! And thanks to those who write the software and run the mailing list. I'm sure this is never said as often as it should be. Regards, Art -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column
You seem to have a fundamental misunderstanding of how spreadsheets work. When you enter a number into a numeric cell, the software converts it into an internal format, which it then displays in the format you specify for the cell. It does not remember the form in which you entered it. Thus, 127.700 and 127.7 are the same number. If you really want to remember the input format, change the format of the cells in the input column (or row) to text before you enter the data. The result will be a textual representation of the number. You can then search for the "number" in the input format. To perform calculations on those numbers, you would then create another column (or row) containing the formula "=value(input cell)" and do the calculations on the resulting values. On Wed, Sep 12, 2018 at 12:36 AM Art wrote: > I have a column of numbers I want to enter into a calc column. > > One of the numbers is 127.700 (for instance). > > So, I copy the number and paste it into the desired column. But, when I > go back and check the contents of the column, it reads 127.7 instead!!! > > And, if I search the spreadsheet for 127.700, there are no hits > > I tried formatting the column to show 3 significant numbers after the > decimal point, which looks goodbut when I check the actual contents > of that cell, it is still 127.7!!! And, I still can't search for 127.700 > (no hits)! > > I tried turning off the autocomplete, no change. > > It seems like calc has some sort of deliberate action to inhibit > entering of trailing zero's (after the decimal point). > > How do I turn off this "feature"??? > > When I copy and paste 117.000 into a cell, I expect to see 117.000 when > I examine the contents of the cell. I actually don't have a problem with > how the number is displayed in the spreadsheet, but when I search for > the number I entered into the column, I need to get hits on 117.000 when > I search for 117.000. > > TY > > Art > > > > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column
At 00:36 12/09/2018 -0400, Art Noname wrote: I have a column of numbers I want to enter into a calc column. That may be your first mistake: these may not be numbers. Read on. One of the numbers is 127.700 (for instance). So, I copy the number and paste it into the desired column. But, when I go back and check the contents of the column, it reads 127.7 instead!!! Your punctuation suggests that you are surprised, but you should not be: that is how spreadsheets work. For numbers, the internally stored value has as much precision as is available in the implementation. How the number is *displayed* is a separate issue, and the default will be two fractional places. Only one is shown here because the second fractional place happens to be zero. And, if I search the spreadsheet for 127.700, there are no hits It's difficult to search for floating-point numbers, or even know what is the point of doing so, as calculations will generate rounding errors, and you will not be able to rely on any particular level of precision. You will probably say that you don't want to perform calculations with these values - which would be Good News. Read on. I tried formatting the column to show 3 significant numbers after the decimal point, which looks goodbut when I check the actual contents of that cell, it is still 127.7!!! Actually, the contents will effectively be 127.7 followed by as many zeroes as can be stored in the internal representation. And I hope it will not be a revelation to you to learn that 127.700 and 127.7 are actually equal. If necessary, ask yourself which is larger. Also, in any calculation (carried out to the greatest precision allowed by the internal representation) these values would give identical results. So *as numbers* they are equivalent. At 02:44 12/09/2018 -0400, Art wrote: I'm listing frequencies in Megahertz, so the zeros to the right of the decimal point are significant. That is very true, of course, for representing such a physical quantity. But it is your business to keep track of levels of precision, not the spreadsheet's. It seems like calc has some sort of deliberate action to inhibit entering of trailing zero's (after the decimal point). You can enter them, but yes: what you then see in the cell is controlled mostly by the cell formatting. How do I turn off this "feature"??? By reconsidering the design of your spreadsheet. Read on. When I copy and paste 117.000 into a cell, I expect to see 117.000 when I examine the contents of the cell. Then don't use numbers in a spreadsheet. I actually don't have a problem with how the number is displayed in the spreadsheet, but when I search for the number I entered into the column, I need to get hits on 117.000 when I search for 117.000. So you wish to search for items exactly as you have entered them? And I'm guessing that you will not be doing any calculations with these frequency values: you will not be subtracting one from another to work out how many channels they are separated by, and not averaging a collection of such values? Is that the case? If so, what you have here and need to deal with are actually pieces of text that happen to look like numbers. All you have to do is to format relevant cells (probably columns) as text *before* you enter your values. Problem solved! (You will notice that text values are left-aligned by default, unlike numbers.) If you do need later to perform calculations on these values, you can convert them on the fly to numerical values using the VALUE() function in your formulae. In some contexts, conversion even happens automatically, without the need for that. One word of caution: if you enter values in text-formatted cells by typing, you will get what you need. But you talked of pasting values. If you paste numerically formatted values from another spreadsheet cell into a text-formatted cell, this may change the format of the cell - which you won't want. To avoid that, use Paste Special... instead of ordinary Paste and remove the tick from Formats. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column
On Wed, 12 Sep 2018 02:44:26 -0400 Art wrote: > It seems that the software is ignoring zeros to the right of the > decimal point. I'm listing frequencies in Megahertz, so the zeros to > the right of the decimal point are significant. I wish I could post > my spreadsheet somewhere, I do know better than to send it to the > list members::> As far as I can tell the problem is fairly fundamental. LibreOffice uses a definition of 'significant figure' that is different to that usually used in the scientific world. Specifically, they don't regard a 0 after a decimal point as significant :( See https://help.libreoffice.org/Common/Number_Format_Codes I'd suggest you have two easy options: (1) use a 0.000 format and search using the formatted display option (2) Display the frequencies in kHz so they are all whole numbers Note that you could display the numbers twice in two columns. Once in a column that's easy for you to read, and again in a column that's formatted to be searched. The search column could be hidden. PS I was going to suggest: (3) Use scientific format to specify the significant digits (e.g. ##0.000E+00) but apparently you can't search 127.700E+00 for 127.7 :( -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column
For the formatted display to work, the cells have to be formated to show the decimal places to the degree you want. I have the column set to show just 2 decimal places. So 5 of the cells show 1.08 though the raw numbers are actually slightly different. So, if you set the columns to use the format with 3 decimals, and then click on the as formatted it should work. If not, you might try upgrading to the latest version. Sometimes it is something that is fixed in the newer versions. On 12 Sep 2018 at 2:44, Art wrote: Subject:Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column To: "Michael D. Setzer II" , users@global.libreoffice.org From: Art Date sent: Wed, 12 Sep 2018 02:44:26 -0400 > On 09/12/2018 01:09 AM, Michael D. Setzer II wrote: > > On 12 Sep 2018 at 0:36, Art wrote: > > > > To: users@global.libreoffice.org > > From: Art > > Subject: [libreoffice-users] can't prevent Calc from > > modifying the number I type into a column > > Date sent: Wed, 12 Sep 2018 00:36:02 -0400 > > > >> I have a column of numbers I want to enter into a calc column. > >> > >> One of the numbers is 127.700 (for instance). > >> > >> So, I copy the number and paste it into the desired column. But, when I > >> go back and check the contents of the column, it reads 127.7 instead!!! > >> > >> And, if I search the spreadsheet for 127.700, there are no hits > >> > >> I tried formatting the column to show 3 significant numbers after the > >> decimal point, which looks goodbut when I check the actual contents > >> of that cell, it is still 127.7!!! And, I still can't search for 127.700 > >> (no hits)! > >> > >> I tried turning off the autocomplete, no change. > >> > >> It seems like calc has some sort of deliberate action to inhibit > >> entering of trailing zero's (after the decimal point). > >> > >> How do I turn off this "feature"??? > >> > >> When I copy and paste 117.000 into a cell, I expect to see 117.000 when > >> I examine the contents of the cell. I actually don't have a problem with > >> how the number is displayed in the spreadsheet, but when I search for > >> the number I entered into the column, I need to get hits on 117.000 when > >> I search for 117.000. > >> > >> TY > >> > >> Art > > I just did the ctrl-F in a spreadsheet I have with floating point number. > > Have a > > number of 1.08 as the displayed data, but it only finds one of the 5. If I > > click > > formatted Display option at the bottom, it then finds all of them. > > > > So, that should be on the bottom. I have version 6.1.0.3 on Linux (Fedora) > > not sure which OS you are using or which version. > > > > > > I'm running Xubuntu 18.04, with Version: 6.0.3.2, Build ID: > 1:6.0.3-0ubuntu1. It is fully updated. > > I'm not quite sure I understand your explanation. > > If I open a fresh spreadsheet and enter '117.700' into one cell, then > search for '117.000', there are no hits. When I look at the contents of > the cell, it says '117.7', which isn't the number I entered. I can > search for 117.7 and it will be found, but, 117.76, 117.774 and 117.706 > are also found.which is wrong. > > I did try formatted display checkbox at the bottom of the screen, but > there is no difference. > > It seems that the software is ignoring zeros to the right of the decimal > point. I'm listing frequencies in Megahertz, so the zeros to the right > of the decimal point are significant. I wish I could post my spreadsheet > somewhere, I do know better than to send it to the list members::> > > Any ideas? > > > ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ ++ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS ROSETTA 65783064.026787 | ABC 16613838.513356 SETI109522885.335812 | EINSTEIN141379519.999240 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column
On 09/12/2018 01:09 AM, Michael D. Setzer II wrote: > On 12 Sep 2018 at 0:36, Art wrote: > > To: users@global.libreoffice.org > From: Art > Subject: [libreoffice-users] can't prevent Calc from > modifying the number I type into a column > Date sent:Wed, 12 Sep 2018 00:36:02 -0400 > >> I have a column of numbers I want to enter into a calc column. >> >> One of the numbers is 127.700 (for instance). >> >> So, I copy the number and paste it into the desired column. But, when I >> go back and check the contents of the column, it reads 127.7 instead!!! >> >> And, if I search the spreadsheet for 127.700, there are no hits >> >> I tried formatting the column to show 3 significant numbers after the >> decimal point, which looks goodbut when I check the actual contents >> of that cell, it is still 127.7!!! And, I still can't search for 127.700 >> (no hits)! >> >> I tried turning off the autocomplete, no change. >> >> It seems like calc has some sort of deliberate action to inhibit >> entering of trailing zero's (after the decimal point). >> >> How do I turn off this "feature"??? >> >> When I copy and paste 117.000 into a cell, I expect to see 117.000 when >> I examine the contents of the cell. I actually don't have a problem with >> how the number is displayed in the spreadsheet, but when I search for >> the number I entered into the column, I need to get hits on 117.000 when >> I search for 117.000. >> >> TY >> >> Art > I just did the ctrl-F in a spreadsheet I have with floating point number. > Have a > number of 1.08 as the displayed data, but it only finds one of the 5. If I > click > formatted Display option at the bottom, it then finds all of them. > > So, that should be on the bottom. I have version 6.1.0.3 on Linux (Fedora) > not sure which OS you are using or which version. > > I'm running Xubuntu 18.04, with Version: 6.0.3.2, Build ID: 1:6.0.3-0ubuntu1. It is fully updated. I'm not quite sure I understand your explanation. If I open a fresh spreadsheet and enter '117.700' into one cell, then search for '117.000', there are no hits. When I look at the contents of the cell, it says '117.7', which isn't the number I entered. I can search for 117.7 and it will be found, but, 117.76, 117.774 and 117.706 are also found.which is wrong. I did try formatted display checkbox at the bottom of the screen, but there is no difference. It seems that the software is ignoring zeros to the right of the decimal point. I'm listing frequencies in Megahertz, so the zeros to the right of the decimal point are significant. I wish I could post my spreadsheet somewhere, I do know better than to send it to the list members::> Any ideas? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column
On 12 Sep 2018 at 0:36, Art wrote: To: users@global.libreoffice.org From: Art Subject:[libreoffice-users] can't prevent Calc from modifying the number I type into a column Date sent: Wed, 12 Sep 2018 00:36:02 -0400 > I have a column of numbers I want to enter into a calc column. > > One of the numbers is 127.700 (for instance). > > So, I copy the number and paste it into the desired column. But, when I > go back and check the contents of the column, it reads 127.7 instead!!! > > And, if I search the spreadsheet for 127.700, there are no hits > > I tried formatting the column to show 3 significant numbers after the > decimal point, which looks goodbut when I check the actual contents > of that cell, it is still 127.7!!! And, I still can't search for 127.700 > (no hits)! > > I tried turning off the autocomplete, no change. > > It seems like calc has some sort of deliberate action to inhibit > entering of trailing zero's (after the decimal point). > > How do I turn off this "feature"??? > > When I copy and paste 117.000 into a cell, I expect to see 117.000 when > I examine the contents of the cell. I actually don't have a problem with > how the number is displayed in the spreadsheet, but when I search for > the number I entered into the column, I need to get hits on 117.000 when > I search for 117.000. > > TY > > Art I just did the ctrl-F in a spreadsheet I have with floating point number. Have a number of 1.08 as the displayed data, but it only finds one of the 5. If I click formatted Display option at the bottom, it then finds all of them. So, that should be on the bottom. I have version 6.1.0.3 on Linux (Fedora) not sure which OS you are using or which version. > > > > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ ++ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS ROSETTA 65783064.026787 | ABC 16613838.513356 SETI109522885.335812 | EINSTEIN141379519.999240 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] can't prevent Calc from modifying the number I type into a column
I have a column of numbers I want to enter into a calc column. One of the numbers is 127.700 (for instance). So, I copy the number and paste it into the desired column. But, when I go back and check the contents of the column, it reads 127.7 instead!!! And, if I search the spreadsheet for 127.700, there are no hits I tried formatting the column to show 3 significant numbers after the decimal point, which looks goodbut when I check the actual contents of that cell, it is still 127.7!!! And, I still can't search for 127.700 (no hits)! I tried turning off the autocomplete, no change. It seems like calc has some sort of deliberate action to inhibit entering of trailing zero's (after the decimal point). How do I turn off this "feature"??? When I copy and paste 117.000 into a cell, I expect to see 117.000 when I examine the contents of the cell. I actually don't have a problem with how the number is displayed in the spreadsheet, but when I search for the number I entered into the column, I need to get hits on 117.000 when I search for 117.000. TY Art -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy