View original (French)

Keep number format in concatenate function

Solved
Olivier -  
 FVA -
Hello,

I want to use the concatenate function with 8-digit numbers, knowing that for some numbers the first digits can be 0.
So in my formula, they disappear.

Thank you in advance.

Configuration: Windows 7 / Firefox 35.0

2 answers

  1.
    gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
     
    Hello,

    With the concatenate function (which you can replace with '&'), if you want to keep certain formats you need to include the TEXT function: 
    =TEXT(B1;"00000000")&TEXT(A1;"d/m/yyyy")&TEXT(C1;"# ##0.00 €")

    Thus you have a number of 8 digits, a date, and a monetary amount.
    Always zen
    Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry
    15
    1. Olivier
       
      Thank you, it works.
      Thanks again for your quick response.

      Have a nice day.
      0
    2. FVA
       
      Thank you!!!
      0
  2. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    your title is incompatible with your explanations. If you want leading 0s in concatenation, it must be in text format; otherwise, the 0s will indeed disappear.
    Can you provide an example of the problem with the expected result?
    Looking forward to hearing from you

    --
    To err is human, to persist is diabolic.
    0
    1. Olivier
       
      Everything is good, I wanted to concatenate a link on my disk with a number (Parts Reference).
      Gbinforme solved the problem for me.

      Thank you
      0