[ale] OpenOffice Spreadsheet and Dates

Stephen R. Blevins srblevi at worldnet.att.net
Mon Apr 14 00:06:03 EDT 2008


Have you tried to enter the date as a *text* item.  I would have entered 
it as "05/30/1787  (closing quote mark not needed).

Stephen R. Blevins
srblevi at worldnet.att.net



Robert Reese wrote:
> Hi Brian,
>
> *********** REPLY SEPARATOR  ***********
> On 4/13/2008 at 10:54 PM Brian Pitts wrote:
>
>   
>> Somewhat off topic since OpenOffice is cross-platform, but I'm sure the 
>> list will appreciate a chance to bash Microsoft.
>>
>> I have a spreadsheet in OpenOffice where I've been entering dates like 
>> 5/30/1787. I need to share this spreadsheet with someone using Microsoft 
>> Excel 2003. My problem is that OpenOffice recognizes that a cell in the 
>> format mm/dd/yyyy is a date and treats it differently than if it was 
>> simply text. When I export the document in xls format, OpenOffice 
>> converts 5/30/1787 to -41121. This seems to be the right thing to do 
>> since, according to Microsoft, Excel stores dates as the offset in days 
>>     
> >from January 1, 1990. [0] Unfortunately, Excel can not display any date 
>   
>> before January 1, 1990 (i.e. a "negative" date). Thus I would like 
>> OpenOffice to stop converting what I entered and simply save the text 
>> 5/30/1787. How can I get it to do this without altering every cell where 
>> I've stored a date?
>>
>> [0] http://support.microsoft.com/kb/180162
>>     
>
>
> Try selecting the entire column and changing the format to text and see if that fixes it for you.  Go to Format > Cells > Numbers tab and choose text.  (At least in the Windows version).
>
> Cheers,
> Robert~
>
> ------------------------------------------------------
>    * Microsoft is NOT a standard. *
> ------------------------------------------------------
>
> SIXIT Consulting
> O: (478) 599-1301
> Cell: 678-438-6955 or (478) 599-1300
> Fax: 866-355-3720 (Toll-Free)
>
> 2907-I Watson Blvd
> #308
> Warner Robins, GA 31093-8535
> United States
>
>
>
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://mail.ale.org/mailman/listinfo/ale
>
>   


More information about the Ale mailing list