Blog

Advance Excel Tips -Date and Time

Advance Excel

Advance Excel Tips -Date and Time

Current Date and Time

The best way to insert the current date and time is to use NOW function which takes date and time from the system and returns when you insert it in a cell.

excel tips tricks insert current date time

The only problem with this function is it’s volatile and whenever you recalculate something it updates its value and if you don’t want to do this the best way is to convert it into value.

Otherwise, you can use below VBA code or these methods to insert a timestamp in a cell.

Sub timeStamp()
Dim ts As Date
With Selection
.Value = Now
.NumberFormat = “m/d/yyyy h:mm:ss AM/PM”
End With
End Sub

Categories

Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
Click outside to hide the comparison bar
Compare