Help With EXCEL DATE Insertion

  • Thread starter Thread starter Viswanathan
  • Start date Start date
V

Viswanathan

Hi all,
I'm new to this forum.
I am trying to create a Excel sheet. In that, I would like
to add a colum the first one, which will automatically get
filled with the current date and time (or atleast the
date) and remain static with that date, whenever I create
a new row (something like an Autonumber in ACCESS)
 
I think this is the easiest way
You can use a Shortcut for it

you can insert the time like this
CTRL : (colon)

the date like this
CTRL ; (semicolon)

CTRL : (colon) space bar CTRL ; (semicolon)
this will give you both in one cell


Or a macro for the activecell.row

Sub test()
Cells(ActiveCell.Row, 1).Value = Format(Now, "dd-mm-yy h-mm-ss")
End Sub
 
Back
Top