2011/4/1 Open Office <[email protected]>: > > Dear All; > Can anybody help me out in this issue..I m using Openoffice > 3.3..But whenever i dump some data in > open office from software which supports only xls format the dates changes > for example 01-04-2011 will be > shown as 04/01/2015..So i have to to this manually..Can anyone give some > solution it will be of great help > to me.. > Regards; > Niket Kalamkar
Hello Niket, See Preferences > OOo Calc > Calculate (3rd option) > Date There you find 3 options, the difference between the 3rd and the 1st/2nd option explains why your dates change when you import from xls. It used to be a difference I stumbled upon when I imported xls from Windows into xls in Mac. -- Guy using LibO 3.3.2/OOo 3.3.0 on a iMac Intel DualCore Snow Leopard -- please reply only to [email protected] -- Dodoes can't afford to have headaches -- ------------------------------------------------------------------------ To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] with Subject: help
