I have a time tracker that I use to keep track of time I spend on different jobs. Each job has a code in this format "XXX9999". It works well but excel insists on converting this code "MAR2004" to a date during the macro execution. How do I assign a text field like "MAR2004" to a cell without converting it to a date?

Ok, don't worry - just fixed it by adding the part in <font color=red>red</font color=red> ...

"activecell.value = <font color=red>"'" & </font color=red>jobcode"