| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reformat a date imported from another program
I export data from another program into Excel. This data contains dates
which are formatted like this: yyyymmdd000000. When the data is imported into Excel, the date shows in the cell like #.#####E+13. The formula bar shows the date as it appears in the original program (yyyymmdd000000). How can this date format be converted to mm/dd/yyyy or another date format which excludes extraneous zeros? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I reformat a 6-digit date to general & look the same? | Excel Discussion (Misc queries) | |||
| Copy pasting and reformat Date | Excel Discussion (Misc queries) | |||
| reformat cells for date | Excel Discussion (Misc queries) | |||
| Imported Date Format | New Users to Excel | |||
| Date from imported file | Excel Discussion (Misc queries) | |||
Threaded Mode
