Keep the trailing zero's in TEXTJOIN

[Nanaia]

Greetings again!
Is there a way to get TEXTJOIN to keep the trailing zeros when having it pull numbers? I have the reference cells set up to carry out to three decimal places. When I use TEXTJOIN to combine data (text and numbers) it's removing the trailing zeros that I need on my numbers. I'm having memory issues because I remember being able to do this before I even knew the TEXTJOIN command existed....

Addendum: I remembered using & and got it to work, but it still won't keep the trailing zeros...

Regards,
Nanaia
"Do or do not, there is no try"~Yoda

 

[Marcílio_Lobão]

Nanaia, Good afternoon.

Suppose your cell is C5 and is 1.400

Try to use:

=TEXTJOIN(",', TRUE, "NOW ", TEXT(C5,"0.000"), " IS OK!")

Is that what you want?
I hope it helps.

 

[Nanaia]

Thanks for the suggestion! I'm not sure it'll work with what I've got. This is what I have in the cell (sheets referenced are named CSV and REF):

=REF!$A$2 & CSV!K2 & REF!$A$3 & REF!C2 & REF!$A$4 & REF!$A$5 & REF!$A$6 & REF!U2 & REF!$A$7 & REF!V2 & REF!$A$8

Columns U and V are supposed to be carried out three decimal places, but Excel is dropping the trailing zeros.

Is this clear as mud now?

Thanks again for your help.

Regards,
Nanaia
"Do or do not, there is no try"~Yoda

 

[Marcílio_Lobão]

Nanaia, Good afternoon.

"...Thanks for the suggestion! I'm not sure it'll work with what I've got..."
My suggestion was based on what you said in your message that you were using the TEXTJOIN function.
But as I see in your new message you are only using the & connector.

Try to use:

=REF!$A$2 & CSV!K2 & REF!$A$3 & REF!C2 & REF!$A$4 & REF!$A$5 & REF!$A$6 & TEXT(REF!U2,"0.000") & REF!$A$7 & TEXT(REF!V2,"0.000") & REF!$A$8

Please, tell us if it worked as you want.
I hope it helps.

 

[Nanaia]

You're fabulous! Yes that worked! Sorry about the confusion from me shifting gears on which formula style I was using. I'd changed to & and only wanted to switch back if I had to.
Thank you again!
Regards,
Nanaia
"Do or do not, there is no try"~Yoda

 

[Marcílio_Lobão]

Glad to have helped you.

Have a nice day!

 

[AhoyNC]

Maybe something like this with TEXTJOIN.
This is an array formula and must be entered with

Excel Workbook
	A	B	C	D	E
1	KL	23.000	PL	45.670	GH
2
3	KL23.000PL45.670GH
CTRL-SHIFT-ENTER.