Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
number to date format | Excel Discussion (Misc queries) | |||
Different results: Networkdays versus date subtraction | Excel Worksheet Functions | |||
Number format to date | Excel Discussion (Misc queries) | |||
* next to date format in Formatcells Number tab | Excel Discussion (Misc queries) | |||
Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) |