Adding Date in Column When Barcode is Scanned

I am new to the forum, lots of great info here. I have never worked with any programming in Excel. I have a workbook that I scan barcodes in cells A2:A31. Is there a way to put a time stamp in Column C Range C2:C31? For example, when I scan a barcode in A14, the current date will appear in Cell C14. I think this would have to be done on the code page, but I have no idea how to do it. I also would like for the date to stay the same from save to save and not update from day to day.

Thanks in advance.

Amit,

Thanks for the forumla, I can not get it to work, I went to options and clicked the iterations box, but the cell still shows N/A.