Followed the instructions and now have the new format yyyymmdd; now need to save the new formatted date data into a new column with the new format value?
Can someone help??
Thank you in advance.
Gil, Miami, Fl.
------------------------------------------------------------------------------------------------
Click FORMAT > CELLS > Custom. In the text box in the
middle of the dialog box type yyyymmdd then click OK. In
that cell(s) if you type 1/20/2003 then hit enter 20030120
will be displayed.
Marty
>-----Original Message-----
>Seems like it should be easy but I am stuck..
>
>Any easy way to convert mm/dd/yyyy format in column to
yyyymmdd format
>
>some of the values in my database column for mm or dd
have only 1 digit, and would need 0 fillers in order to
comply with my final database needs
>
>Help?
>
>Thanks in advance
>
Can someone help??
Thank you in advance.
Gil, Miami, Fl.
------------------------------------------------------------------------------------------------
Click FORMAT > CELLS > Custom. In the text box in the
middle of the dialog box type yyyymmdd then click OK. In
that cell(s) if you type 1/20/2003 then hit enter 20030120
will be displayed.
Marty
>-----Original Message-----
>Seems like it should be easy but I am stuck..
>
>Any easy way to convert mm/dd/yyyy format in column to
yyyymmdd format
>
>some of the values in my database column for mm or dd
have only 1 digit, and would need 0 fillers in order to
comply with my final database needs
>
>Help?
>
>Thanks in advance
>
