Hi,
Not sure how to explain this...
I have a cell that has a basic formula that gives me an equation, how can I commit this equation so its not calculated from the formula anymore - so its just text in the cell like if I would have just typed it in manually.
Another example - a cell that has a formula of (=50+50) which equals 100. I want to get ride of the formula (=50+50) but had its equation stay.
Thanks, J
Hi Jason,
Click on the cell to select it.
Copy.
Go Edit > Paste Values.
The formula will be replaced by the last value calculated.
Same process for both cases.
Regards,
Barry
Hi Jason,
Click on the cell to select it.
Copy.
Go Edit > Paste Values.
The formula will be replaced by the last value calculated.
Same process for both cases.
Regards,
Barry
Hi Barry
It seems that we don't understand the question the same way.
My understanding is that the user must set the cell's format to text.
This way it will display the wanted (=50+50)
Yvan KOENIG (VALLAURIS, France) dimanche 3 juillet 2011 12:31:06
iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8
Please : Search for questions similar to your own before submitting them to the community
To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !
You may format the cell as "Text" then Numbers will not attempt to evaluate cells
Hello Wayne
two hours and a half too late 😉
Yvan KOENIG (VALLAURIS, France) dimanche 3 juillet 2011 15:06:52
iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8
Please : Search for questions similar to your own before submitting them to the community
To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !
Thanks guys for the answers! The "Paste Values." was the one I was looking for BUT changing the cell tip to "Text" was valuable also.
Have a great holiday weekend, J
So, one vote for Barry
none for Wayne and me 😉
Yvan KOENIG (VALLAURIS, France) dimanche 3 juillet 2011 17:20:18
iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8
Please : Search for questions similar to your own before submitting them to the community
To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !
Hi Yvan,
My initial reading was the same as yours and Wayne's.
But the opening line and the closing paragraph lead me to think Jason was using "equation" where I would have used "result."
Regards,
Barry
Thanks,
you saw what made the difference, we didn't.
Yvan KOENIG (VALLAURIS, France) dimanche 3 juillet 2011 21:22:55
iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8
Please : Search for questions similar to your own before submitting them to the community
To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !
Committing a formula to plan type/text?
