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-