[請問] excel數字以零開頭:Realtime－線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍

Blogtrottr

批踢踢實業坊 ask 板

Oct 25th 2014, 17:38, by Melodylily

作者Melodylily (薰衣草香的午後)

看板ask

標題[請問] excel數字以零開頭

時間Sat Oct 25 17:38:39 2014

請問要怎麼輸入？比如我要打016 輸入進去顯示都是16 -- Sent from my Android -- ※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 42.66.59.174 ※ 文章網址: http://www.ptt.cc/bbs/ask/M.1414229922.A.9B3.html

→ jdoe: '016 或整欄整列改儲存格格式 10/25 17:41

→ wxtab019: 儲存格格式自定義格式想要3位的話就000 10/25 17:41

→ kanakin: 格式選"文字"也可以 10/25 17:44

→ wxtab019: 如果還要運算的話就... 10/25 17:51

This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions