Can Excel (2003) reverse date from ccyymmdd to mmddccyy?
 

--
Don T

Can Excel (2003) reverse date from ccyymmdd to mmddccyy?
 

Sure, just change the "display format" for date on the cell. If that
doesn't solve your question, please add more info about the problem.

Don wrote:

Can Excel (2003) reverse date from ccyymmdd to mmddccyy?
 

--
Don T


"Bob I" wrote:

Sure, just change the "display format" for date on the cell. If that
doesn't solve your question, please add more info about the problem.

Don wrote:
There is more, the date range is being exported from AS/400 query. When I Define the result fields by creating a macro to reverse the the date format it shows up in Excel as alpha/numeric.

Can Excel (2003) reverse date from ccyymmdd to mmddccyy?
 

"Bob I" wrote:

Sure, just change the "display format" for date on the cell. If that
doesn't solve your question, please add more info about the problem.

Don wrote:
There is more, the date range is being exported from AS/400 query. When I Define the result fields by creating a macro to reverse the the date format it shows up in Excel as alpha/numeric.


First lose the sig separator in whatever your sending this from, it
tries to kill the message if I reply. If the date is being exported as
text, then it really isn't a date, it's just text that appears to be a
date. If you can't arrange the export to look correct, you could
rearrange it in a helper column. Assume the "date" is in A1, place the
following in the column you want the rearranged "date".
=RIGHT(A1,4)&LEFT(A1,4)

Can Excel (2003) reverse date from ccyymmdd to mmddccyy?
 

On 24 Jul, 18:28, Don wrote:
--
Don T

'yymmdd' I understand. Am I being a little slow what is cc, it is not
something I recognize.

yy/mm/dd=07/12/24
mm/dd/yy=12/24/07

A bit more info might help

Matthew

Can Excel (2003) reverse date from ccyymmdd to mmddccyy?
 

If your values are really dates, you can change the format of those cells to
mmddyyyy.

If those values are just plain old numbers and those values are in a single
column, you can

Select the column
Data|Text to columns|Fixed width
(remove any lines that excel guessed)
and choose ymd as the order of the date.

You'll end up with real dates in those cells.

And now you can format them (format|cells|number tab|custom category) as:
mmddyyyy



Don wrote:

--
Don T

--

Dave Peterson

Can Excel (2003) reverse date from ccyymmdd to mmddccyy?
 

I believe cc is century but could be wrong.

2007 is ccyy is my guess.


Gord Dibben MS Excel MVP

On Tue, 24 Jul 2007 14:59:46 -0700, Matthew wrote:

On 24 Jul, 18:28, Don wrote:
--
Don T

'yymmdd' I understand. Am I being a little slow what is cc, it is not
something I recognize.

yy/mm/dd=07/12/24
mm/dd/yy=12/24/07

A bit more info might help

Matthew