Re: Open Office formatting

Rethabile Mogajane wrote:
> Hello,
>
> I need help with formatting my Date column in Open office. Currently the default
> view is DD/MM/YYYY and I would really appreciate if I could change the
> formatting to YY/MM/DD.
>
> I tried ‘format cell’ and still I can’t seem to be able to change it. Please help
>
> Kind regards,
>


I am guessing that this in Calc.  Right click, select Format Cell.  In 
the pop-up under the Number tab, select Date.  Now under the Format 
column click the format that shows  199-12-31.  In the Format code box 
delete the first two "Y".  Click "OK" to save and close the pop-up.  The 
date format you need should now be shown in the cell.  Just remember 
that this formatting is only for display not how that the data is entered.

HTH
Andy
-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help