设置单元格格式:自定义为:yyyy-mm-dd 如图所示: [img]http://dl.iteye.com/upload/attachment/479278/dd924fb0-bdfb-359f-9b9c-2a13d8c764c4.jpg[/img]