CPHennessy <[EMAIL PROTECTED]> wrote: >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 >
Thanks, for your answer. Yes I Know about the advantage of Paste Special "function", but in this case is necesary to copy a range or cell to convert it to values. In the last week, I was working in many accounting operations and really, saw that, a function "convert to value", can be very usefull, for habitual and common operations, that not include the more sofisticated isues like copy and paste special. Just press right button and convert this cell (or selected ones) in values. (ideas for loose people :-)) Really thanks, for your mail. Elio __________________________________________________________________ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
