ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   DATE (https://www.excelbanter.com/excel-worksheet-functions/248874-date.html)

无名[_2_]
DATE
 
Feb 28,2008 --- 2008-2-28
Feb 1,2008 --- 2008-2-1



Bernard Liengme
DATE
 
Format?

"无名" wrote in message
...
Feb 28,2008 --- 2008-2-28
Feb 1,2008 --- 2008-2-1

Eduardo
DATE
 
See your other post

"脦脼脙没" wrote:

Feb 28,2008 --- 2008-2-28
Feb 1,2008 --- 2008-2-1


.

Eduardo
DATE
 
Hi,
Highlight the cell, right click in the mouse, cell format, custom format and
enter

yyyy-mm-dd

"脦脼脙没" wrote:

Feb 28,2008 --- 2008-2-28
Feb 1,2008 --- 2008-2-1


.


All times are GMT +1. The time now is 03:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com