Trouble with zeros after decimal points being removed in linked cells.

[jbarrick007]

6.10

| DEMO/UNDERGROUND

#6.1 | DEMO/UNDERGROUND

I have cell A1 that has a number. If the cell is in general format 6.10 automatically becomes, 6.1. I know how to change it to a number with 2 decimal points so that it show 6.10. But even when I do that when I use textjoin for C3 it removes the zero.

I cant really change A1 to text because of what im doing C3 is looking for a number with the following formula; =IF(AND([@[Workflow '# ]]>1,[@[Workflow '# ]]<10),(TEXTJOIN(CHAR(10),TRUE,"#"&[@[Workflow '# ]]&" "&[@[Milestone Name ]],"")


Any suggestions on how to get C3 to say "#6.10 | DEMO/UNDERGROUND"

Thanks so much for you help.

 

[Fluff]

How about
TEXTJOIN(CHAR(10),TRUE,"#"&TEXT([@[Workflow '# ]],"#0.00")&" "&[@[Milestone Name ]],"")

 

[jbarrick007]

How about
TEXTJOIN(CHAR(10),TRUE,"#"&TEXT([@[Workflow '# ]],"#0.00")&" "&[@[Milestone Name ]],"")

Wow amazing that works. Thanks so much Fluff. You have helped on several on my problems.

 

[Fluff]

You're welcome & thanks for the feedback.