I am sending data to an EXCEL spreadsheet and then on to a user. The field is a customer number with the value of 2MAY01. EXCEL thinks it is a date but I want it to default as text. I seem to remember something a while back about this but I've slept a few times and cannot remember.
Is there a character of something that can be put in front of the customer number data to force EXCEL to not think it is a date?
Thanks!
Is there a character of something that can be put in front of the customer number data to force EXCEL to not think it is a date?
Thanks!
Comment