Date versus number format

[Chuck Bennett]

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]

Either preformat the cell as Text, then enter the value

or

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

 

[Dave Peterson]

Either preformat the cell as Text, then enter the value

or

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

 

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

 

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

 

[Dave Peterson]

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.

 

[Dave Peterson]

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.