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

  • Thread starter W. Boehmke, Jr.
  • Start date
W

W. Boehmke, Jr.

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

Bernie Deitrick

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

HTH,
Bernie
MS Excel MVP
 
W

W. Boehmke, Jr.

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

Corey

Right Click > Format Cells > Number > Custom

Type: mm-dd-yy

This should give you the result you want
 
G

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
 
W

W. Boehmke, Jr.

BWA HA HA HA HAAAAAA!

Thank you, Corey.

"Doh!"

Now I'm DANGEROUS!

Bill B.
 
W

W. Boehmke, Jr.

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