Excel takes its date formatting from StartSettingsControl Panel.

Open that and make changes to your Regional and Language Settings short date
format.


Gord Dibben MS Excel MVP

On Wed, 1 Mar 2006 12:02:27 -0800, W. Boehmke, Jr.
wrote:

Dear Mr. Deitrick,

Thank you for responding, but I want to show the date numerically.

It seems that the only options available in the "Format Cell" "Date"
categories involve the month spelled out or abbreviated, i.e. "01-Mar-06".

I want to show dates as "03-01-06" and it gets converted to "03/01/06".

I'm using this in conjunction with ANSI Drafting Standards which recommend
not using slashes when depicting dates. I want to include this format in the
Excel spreadsheets I am using for a drawing log.

Thank you for your consideration of my question.

Bill Boehmke, Jr.

"Bernie Deitrick" wrote:

Format the cell for date, and choose the example date that uses hyphens.

HTH,
Bernie
MS Excel MVP


"W. Boehmke, Jr." <W. Boehmke, wrote in message
...
I want to use hyphens instead of slashes when representing dates in Excel.