This topic has been archived. It cannot be replied.
-
工作学习 / 求学深造 / 有大侠知道在EXCEL里，有一格时间显示，不管我怎么该，就是先写日后写月比如： 2012年10月2号，总是显示02/10/2012，如果想该成10/02/2012，怎么处理？谢谢
-celialtj(念念不舍);
2012-12-17
(#7959057@0)
-
Format cell 里调好你想要的格式就行了。
-402(WOW);
2012-12-17
(#7959070@0)
-
把那列删掉，重新插一列？
-forroomrent(roomforrent);
2012-12-18
(#7959566@0)
-
The date format relates to the location. Go to "Format Cell, select "Number" tab, at the bottom of right panel, switch the locations between "English (U.K.)" and "English (U.S.)" . You should be able to get the format you want.
-icemove(icemove);
2012-12-18
(#7959604@0)
-
多谢，学了一招。
-forroomrent(roomforrent);
2012-12-18
(#7960059@0)