求EXCEL高手解答，A2、B2、C2、D2、E2的数据以“：”分隔自动出现在F列

Question

如题所述

Answer 1

如果您要求小数点位数，那么就在F2键入
=TEXT(A2,"#0.00")&":"&TEXT(B2,"#0.00")&":"&TEXT(C2,"#0.00")&":"&TEXT(D2,"#0.00")&":"&TEXT(E2,"#0.00")

Answer 2

F2单元格公式：

=A2&"："&B2&"："&C2&"："&D2&"："&E2

Answer 3

F2输入
=A2&":"&B2&":"&C2&":"&D2&":"&E2