Stupid Excel and Dates (XL 2002)

Topic

New Reply

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 red …

“activecell.value = “‘” & jobcode”

Reply | Quote