CODEWITHSUNDEEP
excelexcel-formula
Asad Alamdar
Asad Alamdar

Reputation: 156

How to Keep the date Format in a Particular Formula?

How to Keep the date Format in a Particular Formula ?

Exemple :

enter image description here

NB : I Use French Excel

Upvotes: 1

Views: 137

Answers (2)

AranDG
AranDG

Reputation: 406

You could format the date as text in your formula:

=E5&":"&TEXT(F5,"DD/MM/YYYY")

edit: And of course, hypothetically speaking, if you were in France:

=E5&":"&TEXTE(F5;"JJ/MM/AAAA")

Upvotes: 3

ImaginaryHuman072889
ImaginaryHuman072889

Reputation: 5205

= E5&":"&TEXT(F5,"dd/mm/yyyy")

Upvotes: 3

Related Questions