software

Hi!

I am running Data-gt;Text to Columns on the date column of my excel
spreadsheet. I would like it to have the MM/DD/YYYY format. The only
format available close to what I need is MDY which basically converts
all values in the column into MM/DD/YY (only 2 digits for a year).

Is there a way to specify the format that would keep year as 4-digit
number? Is there a way to customize this command?

I was adviced by one Excel guru to do this operation so I can correctly
sort my spreadsheet by the date column.

Thanks.Try this:

Select your date cells
lt;Formatgt;lt;Cellsgt;lt;Number tabgt;
Category: Custom
Type: mm/dd/yyyy

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot; wrote:

gt; Hi!
gt;
gt; I am running Data-gt;Text to Columns on the date column of my excel
gt; spreadsheet. I would like it to have the MM/DD/YYYY format. The only
gt; format available close to what I need is MDY which basically converts
gt; all values in the column into MM/DD/YY (only 2 digits for a year).
gt;
gt; Is there a way to specify the format that would keep year as 4-digit
gt; number? Is there a way to customize this command?
gt;
gt; I was adviced by one Excel guru to do this operation so I can correctly
gt; sort my spreadsheet by the date column.
gt;
gt; Thanks.
gt;
gt;


The Text-to-Columns wants to know the input format, (ie, MD or DM) it is
not concerned with the output format.
Dates are stored as numbers, see
www.mvps.org/dmcritchie/excel/datetime.htm for a more detailed
explanation.
You can set or pre-set the displayed Date to whatever form you wish.

Hope this helps

--
Wrote:
gt; Hi!
gt;
gt; I am running Data-gt;Text to Columns on the date column of my excel
gt; spreadsheet. I would like it to have the MM/DD/YYYY format. The only
gt; format available close to what I need is MDY which basically converts
gt; all values in the column into MM/DD/YY (only 2 digits for a year).
gt;
gt; Is there a way to specify the format that would keep year as 4-digit
gt; number? Is there a way to customize this command?
gt;
gt; I was adviced by one Excel guru to do this operation so I can
gt; correctly
gt; sort my spreadsheet by the date column.
gt;
gt; Thanks.--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=536973