Trying to convert m/dd/yyyy to mm/dd/yyyy

pack605

New Member
Joined
Dec 11, 2018
Messages
18
I need the leading 0 in the single months. I have 1/01/2019 and want it to be 01/01/2019.
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,023
Office Version
365
Platform
Windows
Have you tried changing the cell format?
 

Aryatect

Active Member
Joined
Jun 17, 2019
Messages
308
Hi, 2 ways:

1. Go to Number Format and change to mm/dd/yyyy
2. If number stored as text is ok then =TEXT(A1,"mm/dd/yyyy")
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,465
Office Version
365
Platform
Windows
I don't se a mm/dd/yyyy format when I select date.
You choose the Custom format option, and type in mm/dd/yyyy yourself.
 

pack605

New Member
Joined
Dec 11, 2018
Messages
18
Hi, 2 ways:

1. Go to Number Format and change to mm/dd/yyyy
2. If number stored as text is ok then =TEXT(A1,"mm/dd/yyyy")
Not sure on the first one as I don't see mm/dd/yyyy in the Number format but the second one worked.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,465
Office Version
365
Platform
Windows
Not sure on the first one as I don't see mm/dd/yyyy in the Number format but the second one worked.
See my previous reply on 1.
On 2, just be aware that will return a Text value, not a valid Date (in case you need to use it for anything).
 

Watch MrExcel Video

Forum statistics

Threads
1,099,684
Messages
5,470,114
Members
406,681
Latest member
sachinmasurkar

This Week's Hot Topics

Top