ExcelBanter - dates in excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - dates in excel (https://www.excelbanter.com/excel-discussion-misc-queries/115742-dates-excel.html)

barry

dates in excel

How can I enter a date into Excel before jan 1, 1900 and have it be
recognized as a date.. not as text?
Is it possible..
thanks

JMB

dates in excel

I would look here
http://j-walk.com/ss/excel/usertips/tip028.htm

"barry" wrote:

How can I enter a date into Excel before jan 1, 1900 and have it be
recognized as a date.. not as text?
Is it possible..
thanks

All times are GMT +1. The time now is 06:04 AM.