Date format

[Solved/Closed]
Report
-
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
-
Hello,


i have a column in format like 14-02-14 and i want to change it like14-02-2014

1 reply

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
Murshid, Good morning.

Select the cell with the date.
--> Menu Format
--> Cells
--> Number
--> Custom
--> Below the word Type: on the field.
--> Type dd-mm-yyyy

Is it what you want?
I hope it helps.