Excel date format YYYYMMDD


Joined
May 30, 2014
Messages
1
Reaction score
0
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
>

 
Ad

Advertisements

Joined
Jun 28, 2011
Messages
11
Reaction score
0
what is the problem?

icon_biggrin.gif
 

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