Re: Change a formula to an acual number

From: Paul B (newspab_at_surfbest.net)
Date: 02/20/04


Date: Fri, 20 Feb 2004 17:23:08 -0500

Laura, copy, then paste special, valves

-- 
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
"Laura" <anonymous@discussions.microsoft.com> wrote in message
news:A4EDA298-E1D1-4F39-ACB6-2136ACC64473@microsoft.com...
> I want to change the formula I have created to the number it has created.
> Example:  Cell A1 is the number 1.  Cell A2 is the formula =a1+1 creating
> the number 2.  I want this to be a two not a formula.  Any ideas?


Relevant Pages

  • Re: Making a check book ledger
    ... > Please post any response to the newsgroups so others can benefit from it ... >>> Always backup your data before trying something new ... >>> Feedback on answers is always appreciated! ...
    (microsoft.public.excel.newusers)
  • Re: Making a check book ledger
    ... >> Paul B ... >> Always backup your data before trying something new ... >> Please post any response to the newsgroups so others can benefit from it ...
    (microsoft.public.excel.newusers)
  • Re: Inserting a word
    ... >> Always backup your data before trying something new ... >> Please post any response to the newsgroups so others can benefit from it ... >> Feedback on answers is always appreciated! ...
    (microsoft.public.excel)
  • Re: Selecting Print area in protected worksheet
    ... > Paul B ... > Always backup your data before trying something new ... > Please post any response to the newsgroups so others can benefit from it ...
    (microsoft.public.excel.misc)
  • Re: Text to column macro
    ... Paul B ... Always backup your data before trying something new ... Please post any response to the newsgroups so others can benefit from it ...
    (microsoft.public.excel.misc)