Discussion Limiting number of decimals in a VARIABLE SENTENCE in Excel
https://techcommunity.microsoft.com/t5/excel/limiting-number-of-decimals-in-a-variable-sentence/m-p/2144418#M89891
<P>Hello,</P><P> </P><P>I am trying to make a variable sentence that will show the calculations used to arrive at a number i.e. a unit cost*number of units, next to the result.</P><P> </P><P>I am currently using: =" " & I52 & " X " & H17 & " "</P><P> </P><P>Which should give me: ''unit value" X "number of units" (i.e. "7,65 X 90" )</P><P> </P><P>The problem: When calculating i.e. unit value in a different cell, the output comes out with many decimals, i.e. 7,65438828346, instead of 7,65. </P><P> </P><P>The question: How do I limit the number of decimals in my variable sentence?</P>Wed, 17 Feb 2021 21:43:54 GMTMadsnielsen972021-02-17T21:43:54ZLimiting number of decimals in a VARIABLE SENTENCE
https://techcommunity.microsoft.com/t5/excel/limiting-number-of-decimals-in-a-variable-sentence/m-p/2144418#M89891
<P>Hello,</P><P> </P><P>I am trying to make a variable sentence that will show the calculations used to arrive at a number i.e. a unit cost*number of units, next to the result.</P><P> </P><P>I am currently using: =" " & I52 & " X " & H17 & " "</P><P> </P><P>Which should give me: ''unit value" X "number of units" (i.e. "7,65 X 90" )</P><P> </P><P>The problem: When calculating i.e. unit value in a different cell, the output comes out with many decimals, i.e. 7,65438828346, instead of 7,65. </P><P> </P><P>The question: How do I limit the number of decimals in my variable sentence?</P>Wed, 17 Feb 2021 21:43:54 GMThttps://techcommunity.microsoft.com/t5/excel/limiting-number-of-decimals-in-a-variable-sentence/m-p/2144418#M89891Madsnielsen972021-02-17T21:43:54ZRe: Limiting number of decimals in a VARIABLE SENTENCE
https://techcommunity.microsoft.com/t5/excel/limiting-number-of-decimals-in-a-variable-sentence/m-p/2144450#M89896
<P><LI-USER uid="970190"></LI-USER> </P>
<P>For example:</P>
<P> </P>
<P>=" " & TEXT(I52;"0,00") & " X " & TEXT(H17;"0,00") & " "</P>
<P> </P>
<P>(I assumed that you are using comma as decimal separator)</P>Wed, 17 Feb 2021 21:52:14 GMThttps://techcommunity.microsoft.com/t5/excel/limiting-number-of-decimals-in-a-variable-sentence/m-p/2144450#M89896Hans Vogelaar2021-02-17T21:52:14Z