[Solved] Convert cell formula to its value

Discuss the spreadsheet application
Post Reply
hrbolliger
Posts: 4
Joined: Thu Oct 18, 2012 6:25 pm

[Solved] Convert cell formula to its value

Post by hrbolliger »

:D I have a formula (=A1*B1) in a cell. How can I convert the cell to contain the value of the cell ?
Last edited by MrProgrammer on Wed Mar 31, 2021 8:29 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
open Office 3.4.1 on Windows 7
Top
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Calculate functions

Post by Villeroy »

F2, F9, Enter, Enter
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Top
Post Reply

Return to “Calc”