合并多个单元格中的文本时，在Excel中格式化日期 [英] Formating a date in excel when combining text from multiple cells

问题描述

我有一张Excel工作表，其中许多单元格中都有一些文本，需要将它们组合成一个单元格.很容易，除了其中一个单元格是日期外，当合并文本时，您将获得的日期为基数格式，而不是日期格式.

I have an excel sheet with some text in numerous cells and need to combine them into one cell. Easy, except one of the cells is a date and when combining the text you get the date in base number format and not in date format.

示例:

A1 = 一个" A2 = 两个" A3 = "2012年5月12日" A4 = = A1&"& A2&"& A3 = 一个两个41248"

A1 = "One" A2 = "Two" A3 = "05.12.2012" A4 = =A1&" "&A2&" "&A3 = "One Two 41248"

任何人都知道我要在A3之前执行什么操作才能使公式返回05.12.2012而不是41248.我已经尝试过"DATE"和"DATEVALUE"等.

Anyone know what I need to do before A3 in order for the formula to return 05.12.2012 instead of 41248. I have tried "DATE" and "DATEVALUE" etc.

如果是相关事件，则日期是从在数组中查找值的公式得出的.为了便于阅读，我省略了此论坛.

If it is relevent, the date is derived from a formula which looks for a value in an array. I have left out this forumla for ease of reading.

推荐答案

A4 = = A1&"& A2&"& TEXT(A3，"DD.MM.YYYY")

这篇关于合并多个单元格中的文本时，在Excel中格式化日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！