| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I use hyphens instead of slashes when representing dates?
I want to use hyphens instead of slashes when representing dates in Excel.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| prevent converting numbers with hyphens to dates | Excel Discussion (Misc queries) | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Entering DATEs in EXCEL should not require use of "/" slashes. | Excel Discussion (Misc queries) | |||
| numbers contain hyphens to dates | Excel Worksheet Functions | |||
Linear Mode
