Geek asks and answers

How to keep the leading zero and add a comma to the openoffice calc formula?

I have 6 fields in a row in an open office, the 1st word, 2nd, 3rd and 4th numbers - a number with an initial zero, 5th and 6th - regular numbers. How can I combine them with a comma between them to leave level zero?

+5
source share
3 answers

According to your comment about your numbers having a leading 0 in accordance with the user number, you need to include functions TEXT()in the formula in order to save (i.e. add) your leading 0.

=CONCATENATE(A1,",",TEXT(B1,"0#####"),",",TEXT(C1,"0#####"),",",TEXT(D1,"0#####"),",",E1,",",F1)

Just include as many # as possible in this number than the maximum number length.

+9
source

=CONCATENATE(A1,",",B1,",",C1,",",D1,",",E1,",",F1)

, "" ( , Text)

0

, :

=A1&",0"&B1&",0"&C1&",0"&D1&","&E1&","&F1
0

More articles:


All Articles