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


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
 
Ad

Advertisements

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
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,
and would need 0 fillers in order to comply with my final database needs
 
G

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
 
Ad

Advertisements

Joined
Dec 21, 2009
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top