getting date in desired format

ated19

New Member
Joined
Sep 26, 2019
Messages
1
I need date in this format
dd-mm-yyyy
01-02-2019

Specially I need zero before date.
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
46,266
Office Version
  1. 365
Platform
  1. Windows
Welcome to the MrExcel board!

Have you tried formatting the cells/column with the custom format you want? That is dd-mm-yyyy
 

Watch MrExcel Video

Forum statistics

Threads
1,109,149
Messages
5,527,098
Members
409,745
Latest member
CharlesAlsop

This Week's Hot Topics

Top