PC-Talk - Ch? hi?n th? khng ng ?nh d?ng trong Excel 2007

D?ch tiu ? D?ch tiu ?
ong ong
ID c?a bi: 980313 - Xem s?n ph?m m bi ny p d?ng vo.
o?n h?i tho?i sau y s? gi?i thch cho b?n v?n ? g?p ph?i v?i ch? hi?n th? khng ng khi b?n g? vo trong Excel. ? gi?i quy?t v?n ? ny, b?n s? lm vi?c v?i ?nh d?ng c?a cho thu?c tnh c?a ch?
Question Image
Ti g? 1-1 vo v chuy?n sang khc
Thu g?n h?nh ?nh nyBung r?ng h?nh ?nh ny
980313 A


N hi?n th? thnh 1-Jan. T?i sao th? ?
Thu g?n h?nh ?nh nyBung r?ng h?nh ?nh ny
980313 B
Excel c tnh nng t? nh?n gi tr? m b?n nh?p vo v chuy?n ?i thnh d? li?u ? ?c ?nh d?ng t? tr?c

N?u b?n nh?p 1-1 ho?c 1/1, n s? nh?n ra y l d?ng ngy v s? hi?n th? d?ng ngy thng. B?n c th? nh?n trn thanh Formula Bar (thanh cng th?c), n hi?n 1/1/2010
Thu g?n h?nh ?nh nyBung r?ng h?nh ?nh ny
980313 C
answer image
Question Image
Oh, ng r?i. OK, ti c?n ?i ?nh d?ng trong

Ti s? h?ng d?n b?n. ?u tin, nh?p chu?t ph?i vo v ch?n Format Cells.
Thu g?n h?nh ?nh nyBung r?ng h?nh ?nh ny
980313 D
? hi?n th? 1-1 nh b?n ? nh?p, nh?p chu?t vo tab Number trong h?p tho?i Format Cells v nh?p vo danh m?c Text nhng
Thu g?n h?nh ?nh nyBung r?ng h?nh ?nh ny
980313 E
answer image
Question Image
By gi? n l?i hi?n 40179 ! S? ny l g? ?
Thu g?n h?nh ?nh nyBung r?ng h?nh ?nh ny
980313 F
Ngy 2010/1/4 ?c chuy?n ?i thnh s? seri c?a ngy trong Excel

N s? ?m 1 ngy l 1 theo d?ng s? nguyen v ?m t? ngy chu?n (th?ng l 1900/1/1) ?n ngy hi?n t?i.40179 ?c hi?u l ngy th? 40179

B?i v? gi tr? b?n nh?p vo 1-1 ?c chuy?n thnh 2010/1/1 trong ?nh d?ng ngy, theo seri s?. 40179 ? ?c hi?n th? khi b?n ?i ?nh d?ng thnh Text
answer image
Question Image
Ti hi?u, v?y th? lm cch no ? hi?n th? 1-1 ?
Nh?ng i?u b?n c?n lm ? hi?n th? ?nh d?ng ch? tr?c khi b?n nh?p 1-1
answer image
Question Image
Ti hi?u r?i, ti ch? c?n g? l?i 1-1, ph?i khng ? N ? hi?n th? 1-1 c? trong v thanh cng th?c
Thu g?n h?nh ?nh nyBung r?ng h?nh ?nh ny
980313 G
B?n c th? thay ?i ?nh d?ng khng ch? trong m c?n trong b?ng lm vi?c, cc c?t ? ch?n, cc , cc hang ? ch?n. T?t c? vi?c b?n c?n lm l ch?n v sau nh?p chu?t ph?i ch?n Format Cells.
answer image

Thu?c tnh

ID c?a bi: 980313 - L?n xem xt sau cng: 10 Thang Sau 2014 - Xem xt l?i: 1.1
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