Time Stamp
Hello,
I have created a time stamp macro. A very simple one liner.
609140048 ActiveCell.Value = Format(Now(), "yymmddhhmm")
060914_0049 ActiveCell.Value = Format(Now(), "yymmdd_hhmm")
609140050 ActiveCell.Value = CStr(Format(Now(),
"yymmddhhmm"))
These are three different lines I have tried. I want it to be flush
left (text) and to have
the leading zero and as in the middle one but I don't want the
underscore or gap as
in the other ones. How can I get the best of both worlds?
|