Date format

[alexc]

I have a date format dd/mm/yy, but when I double click on it to change the
data, it changes to mm/dd/yy. How can I prevent this from happenning
Thank you

 

[RichardSchollar]

Hi

Sounds to me like the data may actually currently be held as text
rather than as a numeric date (check this by amending the format via
Format>Cells>Number tab (xl2003 and below) or the Number section of
the Home ribbon (xl2007)>Number tab and specify a custom format of dd
mmmm yyyy - if it doesn't change the data, then you have text values
rather than true date numerics).

Hence, what I would suggest is to select the column containing these
'dates' and go Data>TextToColumns>Delimited>Next>Next and choose an
Import Date Format of DMY>clik Finish. (The TextToColumns option lives
on the Data ribbon>Data Tools section in xl2007). This will (or
should) convert the values to dates, in which case you can set the
desired format by the same process above. Excel then shouldn't change
them on editing the cell.

Richard

 

[Stan Brown]

Sat, 29 Dec 2007 10:12:01 -0800 from alexc

I have a date format dd/mm/yy, but when I double click on it to change the
data, it changes to mm/dd/yy. How can I prevent this from happenning

When you say "it changes", I'm guessing that you mean for editing.
That's your system date format, which is completely independent of
the date format you might select for particular cells in Excel. If
you look at the "Details" view in My Computer, you'll see the dates
in the system date format.

If you really, really care about what dates look like when you're
editing them, you'll have to change the system date format with
Control Panel | Language and Regional Settings.

But first ask yourself whether it matters. People are going to see
the worksheet in the formats you selected in Excel, so does it really
matter what the internal date format may be?

 

[alexc]

Sat, 29 Dec 2007 10:12:01 -0800 from alexc


When you say "it changes", I'm guessing that you mean for editing.
That's your system date format, which is completely independent of
the date format you might select for particular cells in Excel. If
you look at the "Details" view in My Computer, you'll see the dates
in the system date format.

If you really, really care about what dates look like when you're
editing them, you'll have to change the system date format with
Control Panel | Language and Regional Settings.

But first ask yourself whether it matters. People are going to see
the worksheet in the formats you selected in Excel, so does it really
matter what the internal date format may be?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/
___________________________________________________________________

Thank you very much, that was the answer to my problem. Have a Prosperous and Healthy new year

 

[Suleman Peerzade]

Hi,

It is excels default setting you cannot change it.