Convert mm/dd/yyyy to yyyymmdd Date format in Excel

R

Rick P.

Seems like it should be easy but I am stuck.

Any easy way to convert mm/dd/yyyy format in column to yyyymmdd forma

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 need

Help

Thanks in advance
 
M

Marty

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
Click to expand...
have only 1 digit, and would need 0 fillers in order to
comply with my final database needs
 
N

Niek Otten

Format>Cells>Custom. In the Type box, enter yyyymmdd

--
Kind Regards,

Niek Otten

Microsoft MVP - Excel
Rick P. said:
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,
Click to expand...
and would need 0 fillers in order to comply with my final database needs
 
R

Rick P

Thank you very much Mart

Worked...
----- Marty wrote: ----

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

Mart

-----Original Message----
Seems like it should be easy but I am stuck.
Click to expand...
have only 1 digit, and would need 0 fillers in order to
comply with my final database need
 
Top