@StarfruitBob指出 num(...) 函数会将字符数据转换为数字。 还有一个 char(...) 函数可以将数字数据转换为字符。
您可能希望使用公式列连接两个数字列。 公式列的公式可能是
char(a) || char(b)
对于数字列 a 和 b。 您可能希望将数字数据保留在数字列中以供进一步工作。 将其转换为字符会导致平台像用 x 拟合 y为数字数据生成错误的报告。
Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.Name is a character variable that will make logistic, contingency, or oneway plots depending on which axis it is used on, and the type of the other axis.名称是一个字符变量,它将根据使用它的轴和另一个轴的类型来制作逻辑图、偶然图或单向图。
Fix Y by X 为两个数字列生成预期的双变量。
您可以使用以下公式将字符工作表列与数字日期列连接在一起
:Character Worksheet || "_" || Format(
:Numeric Date,
"ddMonyyyy",
9
)
或者使用 Concat() 函数
Concat( :Character Worksheet, "_",
Format( :Numeric Date, "ddMonyyyy", 9 )
);
Format() 函数将日期作为字符串返回

右键单击新列的顶部,从弹出菜单中选择公式。 添加公式来做你需要的。
the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.the || is the concatenation operator. There are a bunch of date formats you can choose from.||是串联运算符。 您可以选择多种日期格式。
右键单击列 - >列信息是我通常重新发现格式名称的方式。 我建议为大多数目的起一个很好的名字;可能把年份放在第一位,然后是月、日和页码。 除非你需要所有的工作表 1 一起排序。
the datetime formats are in a separate category.the datetime formats are in a separate category.the datetime formats are in a separate category.the datetime formats are in a separate category.the datetime formats are in a separate category.the datetime formats are in a separate category.the datetime formats are in a separate category.the datetime formats are in a separate category.the datetime formats are in a separate category.the datetime formats are in a separate category.日期时间格式在一个单独的类别中。