SOLVED

How to show 3 or more decimals in Excel when using multiple cells being combined using &?

New Contributor

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.

2 Replies
best response confirmed by jcamargo (New Contributor)
Solution

@jcamargo 

For concatenation transform L5 to text

... & TEXT(L5, "#,##0.000") & ...
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.