| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Date format in imported lotus 123 file
I imported a lotus 123 file for tracking investments. When I try to enter a
date Excel gives me back 1/0/00, which is the beginning of the 20th century. I've tried several date formats to no avail. I also get a flag in the cell saying the date string only has 2 digits for the year. The other data in the sheet appears OK. The date format works OK on a clean sheet. I am using Excel from Office 2003 Basic. Help -- mudslide |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Imported data changes to date format (5-1-5 changes to May 1, 2005 | Excel Discussion (Misc queries) | |||
| Date from imported file | Excel Discussion (Misc queries) | |||
| unable to change date format on imported data | Excel Discussion (Misc queries) | |||
| Imported Data Date Format Problem | Excel Discussion (Misc queries) | |||
| imported impromtu report date issue - fix by format or formula | Excel Discussion (Misc queries) | |||
Threaded Mode
