原帖由 KitBo 於 10-9-7 09:48 發表
無端端,唔知點解會咁?
本來打 9/7 之後個cell 會出 2010/9/7 的日子,
但去咗同file另一個worksheet 打咗 9/7 之後 會出 1900/... 唔記得點show la. 總之會變咗 =9/7.
請各位高人指教吓. ...
Best guess you are using M$ Excel 01. Select the cell or cells, right click and select <cell format>.
In Value tab, select the correct format, say, general / number / currency / date / time ...
Good luck.
"And liftoff, the final liftoff of Atlantis, shoulders of the space shuttle, America will continue the dream."
"Liftoff for the final launch of Endeavor. 'xpending our knowledge, 'xpending our lives in space."
"The final liftoff of Discovery, a tribute to the dedication, hard work and pride of America's space shuttle team."