+ Reply to Thread
Results 1 to 3 of 3

Custom formatting in TEXt or Concat Function

  1. #1
    Registered User
    Join Date
    06-01-2018
    Location
    SF
    MS-Off Ver
    2016
    Posts
    1

    Custom formatting in TEXt or Concat Function

    Hey everyone,

    I am trying to use custom formatting $9.1M (for example) inside a concat formula to combine two numbers and text without losing the custom formatting. I want cell F9 to look like this: $9.0M ($60 / SF). When I try to format the $9,000,000 using TEXT it gives me #value. CAn anyone help with this? Thanks!


    Attachment 576182Attachment 576182
    Attached Files Attached Files
    Last edited by mattyj1234; 06-01-2018 at 04:22 PM. Reason: Needed to attach file

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    18,103

    Re: Custom formatting in TEXt or Concat Function

    Welcome to the Forum!

    We cannot figure out what your question is from just a picture. Please describe what you have, what you want to do, and what you want it look like.

    An image attachment has very little value. Just attach the Excel file. It's easier than taking a screenshot first and then attaching that. The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,226

    Re: Custom formatting in TEXt or Concat Function

    well, as Jeff noted, there is no question so this is a total guess...
    if "values" are in col D, "text" is in col E, "per sf" is in col F and G...
    for your months (120) this =D5&" Months"
    for the TI Allowance this =TEXT(E6,"$#,###")&" ("&F6&" / SF) ("&G6&" / SF)"
    for Total Improvement Estimate this =TEXT(E7,"$#,###")&" ("&F7&" / SF)" which will also work for Capital.
    the rest simply look like you point at the cell with those values in them.
    AGAIN, w/o a question this is just a guess.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Concat Function
    By Vcare in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-04-2018, 07:23 AM
  2. Using Concat function - Not Sorting properly
    By yousuf0203 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-24-2017, 03:24 PM
  3. How do I write a VBA to Bold text in a concat formula?
    By kimmiey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2016, 09:22 AM
  4. Replies: 2
    Last Post: 12-01-2014, 03:25 PM
  5. VBA function help. Concat cells based on parallel value. Function Included!
    By xsa in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-18-2013, 10:18 AM
  6. Replies: 1
    Last Post: 05-25-2012, 11:54 AM
  7. concat function
    By okl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-29-2008, 10:00 AM

Tags for this Thread

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