Date Conversion

[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