VBA Timestamp formatting problem

[rizzo93]

Using VBA, I want a timestamp to show as

7/6/18 15:09
​

but when I use this code

Range("BD3").Value = Format(Now(), "m/d/yy hh:mm")
​

it comes out as 7/6/2018 15:09.


But if I change it to:

Range("BD3").Value = Format(Now(), "m.d.yy hh:mm")


​

it comes out as 7.6.18 15:09

​

What is it about the slashes that make it show 4 digits for the year, and how can it be changed to show only 2, please?

 

[SpillerBD]

Before you populate the cell with a value, Format the Cell.

Range("BD3").NumberFormat = "m/d/yy h:mm;@"

 

[rizzo93]

Thanks, SpillerBD.

With the code change, how/where do I integrate the Now()?

 

[SpillerBD]

Range("BD3").NumberFormat = "m/d/yy hh:mm;@"
Range("BD3").Value = Now()

 

[rizzo93]

Now I understand. Thanks, SpillerBD!