Concatenating just the visible (rounded) values (not the hidden extra, original decimal places)

[thankyou]

...thanks for stopping by my question. i hope you're well. I know how to concatenate, but I'm trying to concatenate 3 already-rounded values to a string, but instead my concatenation is including the original decimal places. For example:

7.2 (already properly rounded to 1 decimal place)
3 (already properly rounded)
6 (already properly rounded)


I'd appreciate the concatenation to read, simply, "7.236"

but instead it's reading too many decimal places on certain of those values. How do you concatenate just the visible values (ie already-rounded values) in those cells? Thanks so much.

 

[Eric W]

You could include the ROUND function as part of the concatenation:

=ROUND(D1,1)&ROUND(E1,0)&ROUND(F1,0)

 

[thankyou]

I like that. I'll try that out. Thank you so much for your time.


ps...yeah worked awesomely thanks again!