Number versus text format
 

We have an application that downloads data into Excel. The project numbers
are in this format: 10-14-09. When the download is executed, the project
number shows up as a date and there is no date format that comes in this
format: 10-14-09. Is there any way to accomplish this?

Number versus text format
 

Check your other post.

Chuck Bennett wrote:

We have an application that downloads data into Excel. The project numbers
are in this format: 10-14-09. When the download is executed, the project
number shows up as a date and there is no date format that comes in this
format: 10-14-09. Is there any way to accomplish this?

--

Dave Peterson

Number versus text format
 

While importing choose the format of the incoming column as TEXT

or add a ' before the project numbers in the program sending the data.

"Chuck Bennett" wrote:

We have an application that downloads data into Excel. The project numbers
are in this format: 10-14-09. When the download is executed, the project
number shows up as a date and there is no date format that comes in this
format: 10-14-09. Is there any way to accomplish this?