Retain Formula when Input is made

Hi,

I'm trying to make a two-in one cell, maybe that's a bad thing, but that document is edited by many people and they are messing formulas all the time

I searched the forum and found one thread with this code:

Please Login or Register  to view this content.

but I can't seem to get it to work for me. Example what I am looking for: if you input 2012 in "B1" it should give it to you as "2012 y. actual". The same would go with C1, D1 and so forth. By the way, where should I input this code, in microsoft Excel Objects tab in "Sheet1 (Sheet 1)" or create a "module"?

Thank you for your help.

If you format cell B1:

Number > Custom > General" y. actual"

You will have your desired result.