date in the form of yyyymmdd

K

kang

other than entering 'yyyy-mm-dd' as date,
are there ways to enter dates "yyymmdd"

if I enter, for example, 20070101 and change the cell format to yyyymmdd
and the cell becomes lots of #.
 
G

Guest

Hi,

You can check various in build date formats in Excel in the following menu,
otherwise you can customize too.

Format-> cells-> caterogy->date.

Hope this will clear your doubt.

Regards,
Soundar.
 

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