About Us

FinChase

Hi,
I need to convert dates that are currently in m/d/yyyy format to yyyymmdd
format. I've tried doing a string function using right, left, and mid, but
I'm getting back the serial date format. Can anyone help with this?

Thanks-

Mike H

hi,

Have you tried

format|Cells|Custom
enter a custom format of
yyyymmdd

Mike

"FinChase" wrote:

Hi,
I need to convert dates that are currently in m/d/yyyy format to yyyymmdd
format. I've tried doing a string function using right, left, and mid, but
I'm getting back the serial date format. Can anyone help with this?

Thanks-

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date Conversion	billbrandi	Excel Discussion (Misc queries)	3	July 23rd 07 03:58 AM
Date Conversion	Port Man	Excel Discussion (Misc queries)	2	March 1st 07 06:40 PM
Date Conversion	MIchel Khennafi	Excel Worksheet Functions	3	July 20th 06 05:56 PM
Date conversion	Kristiaaan	Excel Discussion (Misc queries)	5	July 30th 05 05:49 AM
date conversion	rdunne	Excel Worksheet Functions	2	April 12th 05 10:41 PM

Menu

About Us