Mathematica 9 is now available
Services & Resources / Wolfram Forums
-----
 /
MathGroup Archive
2007
*January
*February
*March
*April
*May
*June
*July
*August
*September
*October
*Archive Index
*Ask about this page
*Print this page
*Give us feedback
*Sign up for the Wolfram Insider

MathGroup Archive 2007

[Date Index] [Thread Index] [Author Index]

Search the Archive

Conversion back to excel date format

  • To: mathgroup at smc.vnet.net
  • Subject: [mg73104] Conversion back to excel date format
  • From: Clifford Martin <camartin at snet.net>
  • Date: Sat, 3 Feb 2007 04:24:10 -0500 (EST)

I have a list of numbers I've calculated. The last element in the list is a date in Mathematica format. I needed it to be in that format to use the Miscellaneous`Calendar functions. When I'm done I output the list (of lists) to a txt file and read it into Excel. (The guy I'm working with can only use Excel).

So the list looks something like this for 1 row

{{a,b,c,d,e,f,g,{2004,11,15}}} where a,b,c,d,e,f,g are numbers I've calculated. I'd like to convert the last element (the date) into a date format compatible with Excel such as 11/15/2004 before I export the data. Any suggestions?

Thanks in advance.

Cliff


  • Prev by Date: How to find all folder within a specified directory?
  • Next by Date: Re: Nice Integrate setting
  • Previous by thread: Re: How to find all folder within a specified directory?
  • Next by thread: Re: Conversion back to excel date format