Convert Excel Serial Values

's Computer Specifications

How do I convert Excel Serial Values in an Outlook message body using VBA?

Lets say 37257 is in the body and I want to convert it to January 31, 2004.

Will VBA do it?

's Computer Specifications

CDate(37257) returns the 1/12002.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook

"amccriri" <(E-Mail Removed)> wrote in message
news:7C80F059-9C1F-487D-AC73-(E-Mail Removed)...
> How do I convert Excel Serial Values in an Outlook message body using
VBA?
>
> Lets say 37257 is in the body and I want to convert it to January 31,
2004.
>
> Will VBA do it?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I convert decimal values to hours & minutes in Excel 2000?	=?Utf-8?B?Qm8wdHM=?=	Microsoft Excel Misc	6	3rd Aug 2007 12:27 AM
How do I convert values in figures to words in EXCEL 2000?	=?Utf-8?B?Sm9obg==?=	Microsoft Excel Worksheet Functions	2	8th Jul 2006 12:28 PM
how do I convert euro values to GBP in excel	=?Utf-8?B?UmVCZWNjYQ==?=	Microsoft Excel Worksheet Functions	1	17th Aug 2005 08:48 PM
how do I convert copied Text numbers into values in Excel?	=?Utf-8?B?TU9F?=	Microsoft Excel Worksheet Functions	1	14th Jun 2005 06:03 AM
How to convert Excel serial date into Access date format?	RADO	Microsoft Access	2	27th Dec 2003 12:14 PM