| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
stop dates format automatically excel 2002
Do you read CSV files? If so, change the name of the file to a .TXT file. Then you will have the opportunity to format each field
the way you like. -- Kind regards, Niek Otten "Harmitage" wrote in message ... | How do I stop excel automatically changing entiries with a / to a date? I am | downloading data such as 7/1 so formatting the cells as text beforehand | doesn't work. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| In Excel, is there a way to enter dates in mm/yyyy format? | Excel Discussion (Misc queries) | |||
| access dates in excel, how to change format? | Excel Discussion (Misc queries) | |||
| Excel: How do I enter a date in one cell & automatically dates adj | Excel Discussion (Misc queries) | |||
| Converting a date in Excel 2002 to a Year/Quarter format | Excel Worksheet Functions | |||
Threaded Mode
