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

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
FormatCellsNumber 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 DataTextToColumnsDelimitedNextNext and choose an
Import Date Format of DMYclik Finish. (The TextToColumns option lives
on the Data ribbonData 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


On Dec 29, 6:12 pm, alexc wrote:
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

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?

--
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/

"Stan Brown" wrote:

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?

--
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

Hi,

It is excels default setting you cannot change it.
--
Thanks
Suleman Peerzade


"alexc" wrote:



"Stan Brown" wrote:

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?

--
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