Time text format?
Hello everyone,
I hope you are all doing well.
I am writing today to inquire about the best formula to transform text from the format DD/MM/YYYY to DDMMYYYY.
For example: 02/04/2024 should be transformed to 02042024.
Thank you!
Tagged:
0
Best Answers
-
Sharing the formulas, and this will work with any separator. Just update the separator line item.
0
Answers
-
0
-
@enneagram test Last time we were looking to solve this problem, and today I found some instructions on the forum, please try reading and this afternoon we will continue the discussion
0 -
Hi , You can use the YEAR , MONTH , DAY functions to get the day , month and year from the date and then combine in one line item using TEXT() function
0