On Tuesday 03 May 2005 20:22, + [EMAIL PROTECTED] wrote: > [ MODERATED ] *********************** > I was working with Calc and Excel this last days, and I see that can be > usefull a "right button" funtion that: > > Change a "formula to value" > b.e.: A3= +11+23 --> formula to value --> A3 = 34 > > and viceversa "value to formula" > A3= 345 --> value to formula --> A3= +345 > > This last functi�n can avoid edit and add the formula sign (= or +); > usefull to change a value that I dont want lose, testing maybe, using the > same cell. > > A3= 35 --> A3= +35 *0.13 (tax calculus in my country :-)) > > Thanks for your time!
Hi Elio As you are not subscribed you may not have seen that: On Wednesday 04 May 2005 08:27, Daniel Rentz wrote: > You can do this already (but not with a single step): > > Copy the cell(s) > Press INSERT key (or from menu Edit->Paste Special) > Deselect "Paste All" and "Formulas" > Select "Numbers" > OK Please reply to [email protected] only. -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
