PC Talk - Hi?n th? ?nh d?ng ngy khng nh ? trong Excel 2007

D?ch tiu ? D?ch tiu ?
ID c?a bi: 972208 - Xem s?n ph?m m bi ny p d?ng vo.
o?n h?i tho?i sau s? gi?i thch cho b?n v?n ? g?p ph?i v?i ?nh d?ng ngy hi?n th? khc ngy b?n ? nh?p trong Excel. ? gi?i quy?n v?n ? ny, b?n s? ch?nh l?i thu?c tnh ?nh d?ng hi?n th? c?a ngy trong
Khi ti g? 2009/06/01 th? n t? ?ng chuy?n thnh 2009/6/1. T?i sao n khng hi?n th? ng nh?ng g? ti g??
answer image
Question Image
Ti hi?u r?ng b?n mu?n hi?n th? s? cho ngy v thng v?i 2 ch? s? b?ng vi?c them s? 0 vo ?ng tr?c, ph?i v?y khng ? B?n c th? lm b?ng cch ch?nh l?i ?nh d?ng c?a . ?u tin, b?n nh?p chu?t ph?i vo c ch?a ngy v ch?n Format Cells.
Thu g?n h?nh ?nh nyBung r?ng h?nh ?nh ny
972208 A
H?p tho?i Format Cells xu?t hi?n.
answer image
Question Image
Ti?p theo, nh?p vo tab Number v ch?n Date trong danh m?c. B?n c th? nh?n th?y m?t s? ?nh d?ng c?a ngy, ng khng ? B?n c th? ch?n ?nh d?ng m?nh thch trong danh sch
Thu g?n h?nh ?nh nyBung r?ng h?nh ?nh ny
972208 B
Hmm. Ti khng t?m th?y ?nh d?ng theo ki?u 2009/06/01 trong danh sch
answer image
Question Image
B?n c th? t?y bi?n ? t?o ra ?nh d?ng .

Nh?p vo Custom trong danh sch v nh?p vo ki?u b?n mu?n t?o, trong tr?ng h?p ny l yyyy/m/d
Thu g?n h?nh ?nh nyBung r?ng h?nh ?nh ny
972208 C
yyyy ?c hi?u l nm, m l thng, d ?c hi?u l ngy ph?i khng
answer image
Question Image
Vng, trong h?p Type text, ?i m thnh mm, d thnh dd v nh?p OK.
Thu g?n h?nh ?nh nyBung r?ng h?nh ?nh ny
972208 D
Tuy?t !! By gi? n ? hi?n th? thnh 2009/06/01.
Thu g?n h?nh ?nh nyBung r?ng h?nh ?nh ny
972208 E
answer image
Question Image
B?n nh? r?ng b?n c th? ?i ki?u l?ch. Nh?p vo Date trong danh m?c, nh?p vo ki?u l?ch trong danh sch v nh?p chu?t vo ? thay ?i
Thu g?n h?nh ?nh nyBung r?ng h?nh ?nh ny
972208 G
OK, ti s? lm v?y
answer image
Question Image
Khi b?n g?p v?n ? v? hi?n th? s? khng ch? v?i ngy, b?n c th? tham kh?o thm PC Talk S? hi?n th? khng chnh xc ?nh d?ng trong Excel 2007.

Thu?c tnh

ID c?a bi: 972208 - L?n xem xt sau cng: 10 Thang Sau 2014 - Xem xt l?i: 1.8
p d?ng
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Office Excel 2003
  • Microsoft Office Excel 2007

Cung cp Phan hi

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com