Results 1 to 1 of 1
Thread: Stupid Excel and Dates (XL 2002)
2005-02-04, 15:06 #1
- Join Date
- Feb 2001
- New York, New York, USA
- Thanked 0 Times in 0 Posts
Stupid Excel and Dates (XL 2002)
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"(Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
Quote: "All Happiness is the release of internal pressure"