Number of digits when merged with text

R

Rasmus

Hi

How do i change the number of digits in the cell if I use this:

=H7 & + " pct."

H7 says "8.7" but the cell gives me "8.67452345345 pct." ?
 
R

Rasmus

You helped me on the way. Thanks for that,
the right one is:

=TEXT(H7;"0,0") & + " pct."


"Mike H" skrev:
 
J

JE McGimpsey

Your change isn't right at all, given that your example used a decimal
point, not a comma.

It's also inefficient - there's no need to add operators and do string
manipulation.

- '&' is the concatenation operator, the '+' is redundant.

- it can be done in one step with the notation you're using:

=TEXT(I6; "0,0 pct.")
 
Top