Date versus number format
 

When I try to enter a project number such as 10-9-09 it replaces the project
number with a date. How do I turn off this feature?

Date versus number format
 

Either preformat the cell as Text, then enter the value

or

Start your entry with an apostrophe: '10-9-09



Chuck Bennett wrote:

When I try to enter a project number such as 10-9-09 it replaces the project
number with a date. How do I turn off this feature?

--

Dave Peterson

Date versus number 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?

Date versus number format
 

I would think this is a question about the application that does the download.

But if it creates a text file that you import, you have some control.

If it creates an excel file, I'd visit the developers of that other program to
show them the problem. Maybe they can include something to make sure that field
is treated as text.

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