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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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
 
How can we convert excel sheet into text format?
In that i need to put everything at a specific space.
like it is specified that column should appear in text
 
Back
Top