Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel having problems with dates earlier than 1900
Hi,
I did a search on the forums here and was unable find any answers.... I did an export of data from another program into an excel format. Some of the dates are in the 1800's and show up as "#########" and when I look at the value of one of the cell shows "-3686" . Other cells show different negative numbers. The cell properties is set to date in the format (mm,dd,yyyy). If I manually enter a date prior to 01/01/1900 it does show up but as text. I do not need to use these dates in any kind of forumla but I do need to print out a list and the dates need to show up in the proper format. Any ideas on how I can easily fix this? Thanks, M |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel having problems with dates earlier than 1900
"Imajica12345" wrote: Hi, I did a search on the forums here and was unable find any answers.... I did an export of data from another program into an excel format. Some of the dates are in the 1800's and show up as "#########" and when I look at the value of one of the cell shows "-3686" . Other cells show different negative numbers. The cell properties is set to date in the format (mm,dd,yyyy). If I manually enter a date prior to 01/01/1900 it does show up but as text. I do not need to use these dates in any kind of forumla but I do need to print out a list and the dates need to show up in the proper format. Any ideas on how I can easily fix this? Thanks, M i found the plugin from the j-walk.com web site... but I am unable to figure out how to convert the data that is already in the cell with the negative number into the proper date format. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel having problems with dates earlier than 1900
Hi Imajica12345. Take a look at this site. It may help:
http://www.j-walk.com/ss/excel/files/xdate.htm. HTH -- Sincerely, Michael Colvin "Imajica12345" wrote: "Imajica12345" wrote: Hi, I did a search on the forums here and was unable find any answers.... I did an export of data from another program into an excel format. Some of the dates are in the 1800's and show up as "#########" and when I look at the value of one of the cell shows "-3686" . Other cells show different negative numbers. The cell properties is set to date in the format (mm,dd,yyyy). If I manually enter a date prior to 01/01/1900 it does show up but as text. I do not need to use these dates in any kind of forumla but I do need to print out a list and the dates need to show up in the proper format. Any ideas on how I can easily fix this? Thanks, M i found the plugin from the j-walk.com web site... but I am unable to figure out how to convert the data that is already in the cell with the negative number into the proper date format. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Problems using Excel 2000 to open/save file saved in Excel 2003 | Excel Discussion (Misc queries) | |||
How can I get Excel 2003 to display dates before 1900 | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
how do I get excel to format dates before 1 jan 1900 | Excel Discussion (Misc queries) |