Add prefix to cell in a table

[Vincent88]

Hi I'm doing a invoice summary worksheet in which I have the first column A in a dynamic table. I prefer to have a vba code to add prefix "INV000" whenever I input the invoice number in the cell.
I use WORKBOOK_SHEETCHANGE below but do not know how to continue. Please help.

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

Dim LastRow As Long
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row

If Target.Column > 1 Or Target.CountLarge > 1 Then Exit Sub
If Target.Row = 1 Then Exit Sub

 

[Saba Sabaratnam]

You could use Custom number formatting as shown below if you do not need "INV000" for reporting or calculating purpose.

Kind regards

Saba