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

[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

 

[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

have only 1 digit, and would need 0 fillers in order to
comply with my final database needs

 

[Niek Otten]

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

--
Kind Regards,

Niek Otten

Microsoft MVP - Excel

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

 

[Guest]

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.

have only 1 digit, and would need 0 fillers in order to
comply with my final database need

 

[MANOJ KUMAR JHA]

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