Dear Master,
How can i add the 0 into 123456 = 0123456 however sometime excel is not allowed it just shown 123456 even i typed 0123456.
Thanks for your help
excel formula
2008-01-10 6:45 pm
回答 (4)
2008-01-10 7:15 pm
✔ 最佳答案
你在你想輸入既果格RIGHT CLICK,然後選選儲存格格式,在數值一版,選擇"文字"
確定後,你在果一格選入0123456,佢就會出現0123456
2008-01-20 8:08 pm
我覺得NorthPointMan較好.
2008-01-10 9:22 pm
you can type '0123456
add ' before enter digit
the most easy method~
add ' before enter digit
the most easy method~
2008-01-10 7:13 pm
an ASTERISK (key next to enter) is required before numbers put
收錄日期: 2021-04-16 17:27:54
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20080110000051KK00810