+ Reply to Thread
Results 1 to 2 of 2

functions are not displaying the results

  1. #1
    janeisaac100@gmail.com
    Guest

    functions are not displaying the results

    For some reason, my functions are not displaying their results in the
    cells. All that shows up is the function itself.

    What am I missing? Here's a simple example of a concatenate function to
    combine two columns that contain the city and the state into one
    column.

    This is also what is displaying in the cell - what should have
    displayed was Peoria, IL

    =CONCATENATE(G3,", ",H3)


  2. #2
    Bob Phillips
    Guest

    Re: functions are not displaying the results

    Perhaps the cell is formatted as text, if so, change the format to General.
    Or you may have formula view, Options>Tools>View and check the Formulas
    checkbox.

    --
    HTH

    Bob Phillips

    (remove nothere from email address if mailing direct)

    <janeisaac100@gmail.com> wrote in message
    news:1140090260.030971.55290@o13g2000cwo.googlegroups.com...
    > For some reason, my functions are not displaying their results in the
    > cells. All that shows up is the function itself.
    >
    > What am I missing? Here's a simple example of a concatenate function to
    > combine two columns that contain the city and the state into one
    > column.
    >
    > This is also what is displaying in the cell - what should have
    > displayed was Peoria, IL
    >
    > =CONCATENATE(G3,", ",H3)
    >




+ 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