| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date format issue
I am exporting database files from a database program into a comma delimited format that can be opened in excel. When I open it in excel, all looks fine except for the date column. The .fil file seems to have locked the date column into the straight number format...for example....10291934. I try to format that column to look like 10/29/1934 but it ends up with most entries in that column looking like this ########## or 10/29/5034. It also says that it's in negative, but I don't know why it says that. No matter how I try to unlock it, or save it in xls format then reformat that column...it refuses to convert. What am I doing wrong? Thanks for any help anyone may provide. -- LadyDoe ------------------------------------------------------------------------ LadyDoe's Profile: http://www.excelforum.com/member.php...o&userid=28826 View this thread: http://www.excelforum.com/showthread...hreadid=485764 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
| format date in excel | Excel Discussion (Misc queries) | |||
| Why Does Date Format Change on Chart | Excel Discussion (Misc queries) | |||
| Date Format - Conversion | Excel Discussion (Misc queries) | |||
| USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
Threaded Mode
