Forum Discussion
jcamargo
Jul 27, 2022Copper Contributor
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 shows this in cell L5: 2,743.200 on its own. It can be any cell.
2. These are the values being used to get below result in number 3:
K5=4
L5=2,743.200
AD5=Rolls
3. When I use this formula: =K5&" "&AD5&" /"&" "&L5&" "&"M2"): I get this:
4 Rolls / 2743.2 M2, and not 4 Rolls / 2743.200 M2
I would like this to show the result in number 3 as: 4 Rolls / 2743.200 M2 after doing what it's in number 3. Is that possible? I already changed the destination cell format to be in number with 3 decimals but I'm not getting what I need.
Any help would be really appreciated.
- jcamargoCopper ContributorThank 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.