Nitin Sakhare

In Excel, you can use the NOW() function to get the current date and time, and you can combine it with custom formatting to display only the timestamp. The NOW() function updates every time the worksheet recalculates, so it will always reflect the current date and time.

Here's a simple example: =NOW()

Sub IncreaseLastThreeDigits()
Dim originalString As String
Dim prefix As String
Dim lastThreeDigits As String
Dim newLastThreeDigits As String

' Example serial number string
originalString = "ABC123456"

' Extract prefix and last three digits
prefix = Left(originalString, Len(originalString) - 3)
lastThreeDigits = Right(originalString, 3)

' Increase the last three digits
newLastThreeDigits = Format(Val(lastThreeDigits) + 1, "000")

' Concatenate the prefix and the new last three digits
Dim newSerialNumber As String
newSerialNumber = prefix & newLastThreeDigits

' Display the result
MsgBox "Original Serial Number: " & originalString & vbCrLf & "New Serial Number: " & newSerialNumber
End Sub