Forum Discussion
Solved
How to show 3 or more decimals in Excel when using multiple cells being combined using &?
Hello everyone, I'm setting a new invoice system and would like to know how to show 3 or more decimals when combining multiple cells by using the & signs; for example: 1. My regular text sho...
Thank you so much, it worked as =K5&" "&AD5&" /"&" "&TEXT(L5,"0.000")&" "&"M2 which both you and Quadruple advised. I had to change the comma to a period because of how my Excel is configured.