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

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
50,673
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,673
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,342
Messages
5,571,657
Members
412,412
Latest member
NWPhotoExplorer
Top