Results 1 to 3 of 3

concatenate formula showing as formula, not text

This is a discussion on concatenate formula showing as formula, not text within the Excel Questions forums, part of the Question Forums category; I have the following formula: =CONCATENATE(B28,0) In B28 is the following text(formated as text):000143 so I want the result to ...

  1. #1
    New Member
    Join Date
    Jul 2003
    Location
    Long Island, NY
    Posts
    30

    Default concatenate formula showing as formula, not text

    I have the following formula:

    =CONCATENATE(B28,0)

    In B28 is the following text(formated as text):000143

    so I want the result to be: 0001430

    I have used the fx button to make sure syntax is correct and cell is formated as text, but we only see the formula, not the result.

    What can we do?

  2. #2
    Board Regular kskinne's Avatar
    Join Date
    Feb 2002
    Location
    USA
    Posts
    1,263

    Default Re: concatenate formula showing as formula, not text

    the reason you see the formula and not the result of the formula is because you have the cell formatted as text. change the format to general


    hth
    kevin

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    65,218

    Default Re: concatenate formula showing as formula, not text

    Quote Originally Posted by kskinne
    the reason you see the formula and not the result of the formula is because you have the cell formatted as text. change the format to general


    hth
    kevin
    ...and hit F2.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com