I am having data in excel and word document. In word I have field defined {MERGEFIELD my_field @ "DD.MM.YYYY"}. I am getting result 05.01.2024 in two lines for some data (this field is dinamic because of previus dinamic names, title, jobs). I would like to have 1. 5. 2024 - without 0 and with spaces between day, month and year together as one field in one line. In word I get 05.01 2024 - in two rows. Thank you very much.
New contributor
pikis is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
-
Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.– Community BotCommented Jul 2 at 9:17
-
= MONTH(A1) & ". " & DAY(A1) & "." & JEAR(A1)– dtc348Commented Jul 2 at 9:24
-
I would like to merge document in word with excel file. I have problem with date field (word document). It does not matter how I wrote mergefield in word, I get date format in two lines. I do not want that. I Want format 1.(space)5.(space)2024 - without leading 0 in day and month and one space after dot. In excel I have field as text.– pikisCommented Jul 2 at 12:14
Add a comment
|