Re: can I format dates older than 1900

Excel doesn't support dates before 1900.

You could just enter the date as text, though.

But if you're doing arithmetic with these dates, you could get John Walkenbach's
addin:

http://j-walk.com/ss/excel/files/xdate.htm

demangeo wrote:
>
> I manage a database for my church and i ran into a problem. Can I format a
> date to YYYY/MM/DD before the year 1900? I changed the format in my file but
> it only affected dated after 1900.

--

Dave Peterson
.

Relevant Pages

  • Re: print contents of a CD
    ... Drag the drive onto the attached file and import the file that appears on the desktop into excel to format it. ... 'Not happy John! ... Defending our democracy', ...
    (microsoft.public.windowsxp.general)
  • Re: What date is7 days from given date in Excel 2000
    ... John C has answered my question, ... "David Biddulph" wrote: ... there a way to have a cell equal to the day of the week in format MON, ... Microsoft Excel MVP ...
    (microsoft.public.excel.misc)
  • Re: How do I add text box styles to a worksheet?
    ... To save the TextBox format in Excel 2003, we can right click on a formatted ... Textbox, and choose "Set AutoShape Defaults" button. ... Microsoft Online Community Support ...
    (microsoft.public.excel.programming)
  • Re: What date is7 days from given date in Excel 2000
    ... "John C" wrote: ... there a way to have a cell equal to the day of the week in format MON, TUE, ... "Bernard Liengme" wrote: ... Microsoft Excel MVP ...
    (microsoft.public.excel.misc)
  • Re: My Pictures in Windows XP Home Edition.
    ... Hi John, ... preview' and 'file format not supported' it says the files are compressed due ... The system restore would have been the perfect answer but when I checked my ... This is not tech support ...
    (microsoft.public.windowsxp.photos)