+ Reply to Thread
Results 1 to 3 of 3

excel 2007 doesn't recognize the formula as a formula

  1. #1
    Forum Contributor
    Join Date
    08-14-2006
    Location
    USA
    MS-Off Ver
    2016
    Posts
    679

    excel 2007 doesn't recognize the formula as a formula

    This only happens when working in a .xls export from Quickbooks saved as 97-2003 in Excel 2007. (never happened in 2000)

    when typing direct or using the function wizard Excel 2007 displays the formula as text instead of displaying the result.

    the only way to get around it is to enter something simple like =2+2 into the cell then edit that formula to the function you really want.
    Formatting the cell to number doesn't do it. Pasting the format from a numeric cell doesn't do it.

    (It's not as simple as clicking "Show Formulas")

    any ideas?

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,799

    Re: excel 2007 doesn't recognize the formula as a formula

    Can't say I've used Quickbooks, but if you see a formula in a cell and it's not working correctly,

    Set the cell format to General (or number, etc.), then select the cell (double-click or F2) and then press Enter. That should convert it to the new format.

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: excel 2007 doesn't recognize the formula as a formula

    An alternative is to highlight the cells/columns -> Data -> Text to Columns -> Finish

+ 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