How do I use hyphens instead of slashes when representing dates?

[Guest]

I want to use hyphens instead of slashes when representing dates in Excel.

 

[Bernie Deitrick]

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

HTH,
Bernie
MS Excel MVP

 

[Guest]

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.

 

[Guest]

Right Click > Format Cells > Number > Custom

Type: mm-dd-yy

This should give you the result you want

 

[Gord Dibben]

Excel takes its date formatting from Start>Settings>Control Panel.

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


Gord Dibben MS Excel MVP

 

[Guest]

BWA HA HA HA HAAAAAA!

Thank you, Corey.

"Doh!"

Now I'm DANGEROUS!

Bill B.

 

[Guest]

Thank you, Mr. Dibben.

Your input is very helpful as well.

Now I can make the settings global for my system.

Very much appreciated.

Bill B.