+ Reply to Thread
Results 1 to 3 of 3

Valid formula remains in cell

Hybrid View

  1. #1
    Wally
    Guest

    Valid formula remains in cell

    I used the function arguments dialog to create and verify the function
    results in a cell. When I select the OK button, the cell content displays
    the formula not the results. I cannot seem to locate why.

    Can anyone tell me why?

  2. #2
    Alan
    Guest

    Re: Valid formula remains in cell

    The cell is probably formatted as Text, format it as General then click in
    the formula in the formula bar and hit F2,
    Regards,
    Alan.
    "Wally" <Wally@discussions.microsoft.com> wrote in message
    news:074AA3FE-24A2-4440-86B5-8F3E2689B820@microsoft.com...
    >I used the function arguments dialog to create and verify the function
    > results in a cell. When I select the OK button, the cell content displays
    > the formula not the results. I cannot seem to locate why.
    >
    > Can anyone tell me why?




  3. #3
    David McRitchie
    Guest

    Re: Valid formula remains in cell

    Hi Wally,
    If the cell is already formatted as General or a number and F2 fixes
    it then you probably have spaces or Char(160). You could Trim the content of
    text cells using the TrimALL macro in
    http://www.mvps.org/dmcritchie/excel/join.htm#trimall

    Also check to make sure that you have calculation set to automatic.
    Tools, Options, calculation (tab), calculation: automatic

    When you change the format from text to number or number to text
    the number format will not change until you reenter data. The TrimALL
    macro will make this a lot easier for redoing large areas of cells
    rather than using F2 then Enter for an individual cell.

    Use of F2 then Enter will reenter data just the same as if you had typed in
    new content. If F2 then Enter works it may serve also serve as
    warning that calculation is not turned on.

    ---
    HTH,
    David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
    My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
    Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

    "Alan" <alan111@ntlworld.com> wrote in message news:%23eJ$kIetFHA.3188@TK2MSFTNGP14.phx.gbl...
    > The cell is probably formatted as Text, format it as General then click in
    > the formula in the formula bar and hit F2,
    > Regards,
    > Alan.
    > "Wally" <Wally@discussions.microsoft.com> wrote in message
    > news:074AA3FE-24A2-4440-86B5-8F3E2689B820@microsoft.com...
    > >I used the function arguments dialog to create and verify the function
    > > results in a cell. When I select the OK button, the cell content displays
    > > the formula not the results. I cannot seem to locate why.
    > >
    > > Can anyone tell me why?

    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1