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

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

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

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.

How do I use hyphens instead of slashes when representing date
 

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.

How do I use hyphens instead of slashes when representing date
 

Right Click Format Cells Number Custom

Type: mm-dd-yy

This should give you the result you want

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

How do I use hyphens instead of slashes when representing date
 

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.

How do I use hyphens instead of slashes when representing date
 

BWA HA HA HA HAAAAAA!

Thank you, Corey.

"Doh!"

Now I'm DANGEROUS!

Bill B.

"Corey" wrote:

Right Click Format Cells Number Custom

Type: mm-dd-yy

This should give you the result you want

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

How do I use hyphens instead of slashes when representing date
 

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.

"Gord Dibben" wrote:

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.