Date Format in Spreadsheet cells

scismgenie

New Member
Joined
Sep 22, 2006
Messages
2
Microsoft seems to think that dates before 1900 do not exist, when I format dates in a spreadsheet, if the date is before 1900 it doesn't reformat, is there a way to get EXCEL to do all the date formats? (Historic dates back to 1000 AD would ne "nice". (I am a historian) Also MILITARY (Julian) date format isn't converted ( 25 May 1988 >> May 25, 1988)
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,109,488
Messages
5,529,164
Members
409,852
Latest member
Perry123
Top