"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