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