Forum Discussion

Copper Contributor

Feb 09, 2024

Solved

too many decimals places returned with concat from field with only two decimals

Hello! I'm learning more complicated excel through here and really appreciate all of your expert help. I haven't been able to find the answer to this... I've tried fixed and trunk, and they return wi...

excel

Formulas and Functions

HansVogelaar
Feb 09, 2024
Luwana1

Use the TEXT function:

=CONCAT([@[Approx Dimentions]],CHAR(10),"Approx Wt (oz): ",TEXT([@[kg to oz]], "0.00"),CHAR(10),CHAR(10),[@description],CHAR(10),CHAR(10),[@Origin])

or

=[@[Approx Dimentions]]&CHAR(10)&"Approx Wt (oz): "&TEXT([@[kg to oz]], "0.00")&CHAR(10)&CHAR(10)&[@description]&CHAR(10)&CHAR(10)&[@Origin]

gorsuchjim

Occasional Reader

Dec 30, 2025

I have the same "too many decimal places" problem with a CONCAT formula, but mine is much simpler and the one that was fixed earlier in this discussion is way over my head. My formula is CONCAT(C83/C84,":1") with the hope of returning a "3.32:1" ratio. Instead, I'm getting "3.31632653051224:1." How can I adjust the number of decimals? Thank you in advance.

m_tarler

Bronze Contributor

Dec 31, 2025

gorsuchjim The answer is still to use the TEXT() function (see Hans' first line). So you want to format a number to a fixed number of decimal places you use TEXT( [number], "format" ) so for 2 decimal places it would be TEXT( [number], "0.00" ). So in your example:

=CONCAT( TEXT(C83/C84, "0.00") ,":1")

so then the result of C83/C84 will be formatted to have 2 decimal places then CONCAT with ":1"

best of luck