Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Excel (2003) reverse date from ccyymmdd to mmddccyy?
-- Don T |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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: |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cant get dd/mm date format in Excel 2003 | Excel Discussion (Misc queries) | |||
How can I covert dates to ccyymmdd? | Excel Worksheet Functions | |||
date format in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 date format bug? | Excel Discussion (Misc queries) | |||
In Excel 2003, entering date without slashes, the date is incorre. | Excel Discussion (Misc queries) |