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

[pack605]

I need the leading 0 in the single months. I have 1/01/2019 and want it to be 01/01/2019.

 

[Fluff]

Have you tried changing the cell format?

 

[Aryatect]

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")

 

[pack605]

Have you tried changing the cell format?

I don't se a mm/dd/yyyy format when I select date.

 

[Joe4]

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]

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.

 

[pack605]

You choose the Custom format option, and type in mm/dd/yyyy yourself.

Perfect.

 

[Joe4]

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).