| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to Change Date Formats
I have a bunch of raw data that I am working with. One of the columns
displays dates and I am trying to strip out the year. If I try to use the YEAR function I get strange answers back. For example: Cell reads: 1/1/2006 Answer using YEAR function: 06/1905 Answer that I want: 2006 My data comes from a CSV file, so I think maybe it is in a different date format than excel uses as a standard. Any suggestions on how to reformat this data or some other formula I can use to get the answer I am looking for? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell color change based on due date | New Users to Excel | |||
| excel date formats changed | Excel Worksheet Functions | |||
| Seed date formats to different year in different cells | Excel Discussion (Misc queries) | |||
| How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) | |||
| How do I set date to change automatically on invoices created wit. | New Users to Excel | |||
Threaded Mode
