date in the form of yyyymmdd
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 #. |
date in the form of yyyymmdd
Look he
http://xldynamic.com/source/xld.QDEDownload.html or he http://www.cpearson.com/excel/DateTimeEntry.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "kang" wrote in message ... | 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 #. |
date in the form of yyyymmdd
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. "kang" wrote: 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 #. |
All times are GMT +1. The time now is 01:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com