Thread: Time Stamp
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Pierce John Pierce is offline
external usenet poster
 
Posts: 93
Default 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?