| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert mm/dd/yyyy to mmddyy
I am pulling data out of a student information system in a txt format, then
open it in Excel to format each field as necessary to submit to a testing center for data purposes. The birthdate comes out as (for example) as 7/23/1996; once it's opened in Excel I use the Format Cells function to change it to 072396 per the testing center's parameters. When I validate the spreadsheet, the value changes to 35269. What do I need to do differently to have the value remain 072396 after validation? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert Julian date to DD/MM/YYYY | Excel Discussion (Misc queries) | |||
| I can't convert from mm/dd/yy to month dd, yyyy | Excel Discussion (Misc queries) | |||
| How do I convert a birthdate format from yyyy/mm/dd to mm/dd/yyyy | Excel Worksheet Functions | |||
| convert date mm/dd/yyyy to dd/mm/yyyy | Excel Worksheet Functions | |||
| Convert 010105 mmddyy text to 01/01/06 | Excel Discussion (Misc queries) | |||
Threaded Mode
