Hello, You can convert the formulas to only keep the values by doing a copy/paste special where what you will keep are only the numbers. To do: select the cells, copy (CTRL-C or Edit > Copy) and then paste special (Edit > Paste Special), and select to keep only the numbers. You may be prompted to inform you that you are pasting over existing data: if so, just accept. Then, if you look in the cells, you should now only have the results of the cells. I recommend you paste to a new worksheet to keep the formulas intact for a future use.
I hope this helps. Rémy. Le dimanche 26 septembre 2021 à 09:05 +1300, Steve Edmonds a écrit : > Hi Miss K. > The purpose of your request is not clear. > For the situation where I want to de-reference a value I use copy and > then paste-special selecting only numbers. > If you want 167 in A1 and 16.7 in A2 so that is stays 16.7 even if A1 > changes then possibly in B1 put =A1/10 then copy B1 and in A2 > paste-special selecting only numbers to paste. > I arrange the type of calculation above so that I can copy/paste- > special > rows or columns at a time. > Steve > > On 26/09/2021 05:02, mxk wrote: > > Users Ahoy: > > > > Is there a way to get LO (v5.2.7.2) calc to extract the numerical > > value from a cell, and use that instead of the cell reference in > > further calculations? > > > > Frinstance, if I have 167 in cell A1, and want 16.7 in A2, how can > > I > > program it, (if at all)? > > > > If I put =A1/10 into A2, A2 will contain A1/10, not 16.7,even > > though > > it will display as 16.7. > > > > I want to get away from cell references and use the contained > > values. > > Can I? > > > > I thought that =VALUE(A1)/10 might work, but the result continues > > to > > use the cell reference, not the contained value. > > > > Miss K > > > > > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ Privacy Policy: http://www.documentfoundation.org/privacy
