Number versus text format

C

Chuck Bennett

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?
 
D

Dave Peterson

Check your other post.

Chuck said:
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?
Click to expand...
 
S

Sheeloo

While importing choose the format of the incoming column as TEXT

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