This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 请教IT大侠：(1)在EXCEL里，怎样把日期1/26/03转换成数字20030126？把时间2:13PM转换成数字1413？ (2)怎样把有"Java Applet Window"字样的视窗另存新挡和打印出来？非常感谢。
-sss(旁观者);
2003-1-26
(#1002594@0)
-
UP. THANKS.
-sss(旁观者);
2003-1-26
(#1002719@0)
-
1. a1=01/26/03, a2=year(a1) & month(a1) & day(a1). be sure format of a1 is date. 2 a1=14:13, a2=hour(a1) & minute (a2)
-lilyba(Sunshine);
2003-1-26
(#1002733@0)
-
真的很有用，可节约很多时间，thanks a lot。但我把01/26/03和14:03分别转成了2003126和143，能转成20030126和1403吗？另外，怎样把有"Java Applet Window"字样的视窗另存新挡和打印出来？再谢。
-sss(旁观者);
2003-1-26
(#1002799@0)
-
嘿嘿，这个以前有讨论过。a2=year(a1)*10000 + month(a1)*100+day(a1)
-guestagain(guest again);
2003-1-26
(#1002889@0)
-
好办法。怎样把有"Java Applet Window"字样的视窗另存新挡和打印出来呢？谢谢。
-sss(旁观者);
2003-1-26
(#1002973@0)