i have an excel sheet with a date column, format is dd.mm.yyyy, locale is norwegian(bokmal). When i concatenate that with other columns, excel sheet shows an error.
I tried the following:
TEXT(A2,"mm.dd.yyy"()) -> excel shows an error
CONCAT(B2,TEXT(A2,"mm.dd.yyy"()) -> excel shows an error.
ANy idea ?
I think the problem is due to non english locale.
Asked
Active
Viewed 41 times
0
Parameswar
- 1,951
- 9
- 34
- 57
-
`=TEXT(A2,"mm.dd.yyy")`? Why the extra parentheses? – BigBen Mar 19 '20 at 16:15
-
typo, sorry about that. This is what i typed: =TEXT(A2,"dd.mm.yyyy") – Parameswar Mar 19 '20 at 16:17
-
Please have a look at the following two posts and see if that resolves your problem: https://stackoverflow.com/questions/37100821/change-date-format-using-substitute-or-replace/37101358#37101358 and https://stackoverflow.com/questions/38000194/difference-between-date-and-time-w-out-work-week-excel/38001028#38001028 – Ralph Mar 19 '20 at 18:32