Keep number format in concatenate function
Solved
Olivier
-
FVA -
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
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 réponses
Hello,
With the concatenate function (which you can replace with '&'), if you want to keep certain formats you need to include the TEXT function:
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
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
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.
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.
Thanks again for your quick response.
Have a nice day.