C
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?
number with a date. How do I turn off this feature?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
Either preformat the cell as Text, then enter the value
or
Start your entry with an apostrophe: '10-9-09
or
Start your entry with an apostrophe: '10-9-09
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?
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
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.
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.