Services & Resources / Wolfram Forums
-----
 /
MathGroup Archive
2004
*January
*February
*March
*April
*May
*June
*July
*August
*September
*October
*November
*December
*Archive Index
*Ask about this page
*Print this page
*Give us feedback
*Sign up for the Wolfram Insider

MathGroup Archive 2004

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

Search the Archive

Re: Date format in Excel

  • To: mathgroup at smc.vnet.net
  • Subject: [mg48468] Re: [mg48395] Date format in Excel
  • From: Omega Consulting <info at omegaconsultinggroup.com>
  • Date: Mon, 31 May 2004 00:14:03 -0400 (EDT)
  • References: <200405280450.AAA18383@smc.vnet.net>
  • Sender: owner-wri-mathgroup at wolfram.com

On May 27, 2004, at 11:50 PM, trousseauc at post.ch wrote:

> Hello,
>
> I am in Excel and work with Mathematica. I want to use a Excel Cell 
> with
> the format "date" so that I can call it und use it in another
> mathematica function. But the format convert automatically to a 
> standart
> format so that i can't use the content of the cell in a function who
> need a date.
> Example:
> - Cell M11: 25.05.2004
> - =Math("Names";M11) gives me Names[38132]
> Do you no if I can use the content of Cell M11 as a sting or make a 
> List
> of it ({25,05,2004}}?
> I hope you can help me or guide me to a user group.
> Thank you, have a nice day,
>
> Carole Trousseau

I don't know why you'd use Names on such a creature, but you can 
convert to Mathematica date format with the following formula:

ToDate[(38132 + 2)*(60*60*24)]

{2004,5,29,0,0,0.}

A little bit of post-processing with ToString and you should be able to 
create whatever string you like from that.

----------------------------------------------
Omega Consulting
The final answer to your Mathematica needs.
http://omegaconsultinggroup.com


  • Prev by Date: Re: SetPrecision - What does in find?
  • Next by Date: Re: 3D fitting of data points
  • Previous by thread: Date format in Excel
  • Next by thread: Re: point intersection in space