d******s
发帖数: 228 | 1 A Column in date format:
11/11/2012
When I use function =concatenate(A1), the result comes out as 41224 rather
than 11/11/2012. Any one can help? |
p**m
发帖数: 3876 | 2 =concatenate(TEXT(A1,"mm/dd/yyyy")) |
r********n
发帖数: 7441 | 3 Excel 函数基本用的就是 Basic 的语法，字串连接一般用 &
e.g.
= "Hello" & " " & "world!"
【在 d******s 的大作中提到】
: A Column in date format:
: 11/11/2012
: When I use function =concatenate(A1), the result comes out as 41224 rather
: than 11/11/2012. Any one can help?
|
p**********l
发帖数: 1160 | 4 If you do format cells, the result 41224 can be formatted back to the date
format. |
d******s
发帖数: 228 | 5 Thank you very much!!!
【在 p**m 的大作中提到】
: =concatenate(TEXT(A1,"mm/dd/yyyy"))
|
