Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Time Stamp | Excel Worksheet Functions | |||
time stamp | Excel Worksheet Functions | |||
Time Stamp | Excel Discussion (Misc queries) | |||
time stamp a cell that doesn,t change when time stamping another | Excel Programming | |||
Time Stamp | Excel Programming |