+ Reply to Thread
Results 1 to 3 of 3

Decimals in Formula

  1. #1
    Mestrella31
    Guest

    Decimals in Formula

    how do I turn This:
    ="This totals need to consider "&(ROUND(SUM(G28:G32),2))

    Into This:
    This totals need to consider 171,150.00

    And Not
    This totals need to consider 171150.00


  2. #2
    Jason Morin
    Guest

    Re: Decimals in Formula

    ="This totals need to consider "&TEXT((ROUND(SUM
    (G28:G32),2)),"#,###.00")

    HTH
    Jason
    Atlanta, GA

    >-----Original Message-----
    >how do I turn This:
    >="This totals need to consider "&(ROUND(SUM(G28:G32),2))
    >
    >Into This:
    >This totals need to consider 171,150.00
    >
    >And Not
    >This totals need to consider 171150.00
    >
    >.
    >


  3. #3
    Earl Kiosterud
    Guest

    Re: Decimals in Formula

    Trella,

    Here's a way that maintains the value in the cell (not a string that
    includes "This totals..." So another formula can refer to it, if necessary,
    to get the value.

    Put this in the cell:
    =ROUND(SUM(G28:G32),2)

    Format (Format - Cells - Number - Custom):
    "This totals need to consider" #,##0.00

    --
    Earl Kiosterud
    mvpearl omitthisword at verizon period net
    -------------------------------------------

    "Mestrella31" <[email protected]> wrote in message
    news:[email protected]...
    > how do I turn This:
    > ="This totals need to consider "&(ROUND(SUM(G28:G32),2))
    >
    > Into This:
    > This totals need to consider 171,150.00
    >
    > And Not
    > This totals need to consider 171150.00
    >




+ 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