• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. D

    How to get defined format to carry over into CONCATENATE function

    I have a cell format of '0.0.0' set for column A. In column B I have a CONCATENATE function =CONCATENATE('the number: ',A1') If I type '2.1.2' into A1, then B1 shows 'the number: 2.1.2' If I type '2' into A1 it is re-formatted (properly) to 2.0.0, but the concatenate function shows...
Back
Top