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

jbarrick007

New Member
Joined
Jul 9, 2020
Messages
36
Office Version
  1. 365
Platform
  1. Windows
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.
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
50,807
Office Version
  1. 365
Platform
  1. Windows
How about
TEXTJOIN(CHAR(10),TRUE,"#"&TEXT([@[Workflow '# ]],"#0.00")&" "&[@[Milestone Name ]],"")
 

jbarrick007

New Member
Joined
Jul 9, 2020
Messages
36
Office Version
  1. 365
Platform
  1. Windows
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
50,807
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,656
Messages
5,573,432
Members
412,529
Latest member
cTatch
Top