[請問] Excel問題，數值自動*10?:Realtime－2016【韓劇】奶酪陷阱劇情簡介及人物介紹奶酪陷阱 EP03 預告奶酪陷阱線上看奶酪陷阱(捕鼠器裡的奶酪) 第1集

Blogtrottr

批踢踢實業坊 ask 板

[請問] Excel問題，數值自動*10?

Apr 28th 2015, 12:43, by hirorei

作者hirorei (深井有貓餅)

看板ask

標題[請問] Excel問題，數值自動*10?

時間Tue Apr 28 12:43:03 2015

請問Excel有沒有辦法key的數值自動*10 除了從選項的自動插入小數點的辦法以外? google了好久都找不到辦法QQ 因為檔案有很多電腦要用，所以可能要從公式下手沒辦法改excel的設定謝謝 -- In other words, hold my hand; in ▉▉ ▁▂▂ `◣▊◤▁▂/▉▍▎▊ / p other words, darling, kiss me. iss ▎︱｛ ◥‘‵◥ ◥▏′‘◤▊▋▍▋ a Ｆｌｙ　Ｍｅ　ｔｏ　ｔｈｅ　Ｍｏｏｎ |▉ ▍▇ ` ▇◤ /▊▋▏'/ i Fill my heart with songs and let me▊ ▏▊◣ ι ◤﹊ ▉ ◤ / n sing forevermore; you are all I long◥▎ ◣ ` ◤▁- |∥▉∕ t for, all I worship and adore. In other ◣ ㄧ ′▋ ∕▉▋/ e -- ※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 220.128.225.178 ※ 文章網址: https://www.ptt.cc/bbs/ask/M.1430196187.A.F88.html

推 gbcowandy: B1=A1*10 04/28 12:48

→ hirorei: sorry,我要同一格自動變10倍 04/28 12:53

→ hirorei: 儲存格格式用@“10“ 04/28 13:12

推 higger: #,###"0"...自訂格式改這樣...但...只是看起來加0... 04/28 13:15

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