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

  • Thread starter Thread starter Guest
  • Start date Start date
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:
 
Bob I said:
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.
Click to expand...

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)
 
'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
 
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
 
I believe cc is century but could be wrong.

2007 is ccyy is my guess.


Gord Dibben MS Excel MVP
 
Back
Top