Forum Discussion
abiddlecomb1
May 10, 2018Copper Contributor
How to combine cells without loosing various decimal places? (i.e., 0.50+U=0.50U, or 10.0+U=10.0U)
How do I combine or concatenate columns of data where one column is numbers with various decimal places and the other column is text? I do not want to loose the decimals places. Concatenate woul...
Detlef_Lewin
May 10, 2018Silver Contributor
Hi,
use the TEXT() function to set a number format.