date format in sheets

H

hitarth

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

in the XL preferences, i hv set the date to read as DD/MM/YYYY. hence the date if entered as 26/3/09 .. must read as 26-Mar-2009. but on doing this .. ( i.e. entering 26/3/09, the date will show as thu ... but if i have to have the date to show as 26-Mar-2009 ( as set in the preferences ) , i have enter it as 3/26/09 !!!
 
L

Laroche J

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

in the XL preferences, i hv set the date to read as DD/MM/YYYY. hence the date
if entered as 26/3/09 .. must read as 26-Mar-2009. but on doing this .. ( i.e.
entering 26/3/09, the date will show as thu ... but if i have to have the date
to show as 26-Mar-2009 ( as set in the preferences ) , i have enter it as
3/26/09 !!!
Click to expand...

The answer is not in Excel preferences, but rather in OS X's International
preferences. Check it out.

JL
Mac OS X 10.4.11, Office v.X 10.1.9
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Local Date Format in Excel 1
Date Formats for Cells Do not match System Date Formats 5
Excel date issue 2
British Date Formats 2
Excel date formatting 2
date format not working 1
Can't sort by date 2

Top