1. PTT
  2. ask

[请问] EXCEL储存格数值设定

楼主: TWOOOOOOOOOO (给妳2亿)   2014-08-10 16:05:11
请问各位
EXCEL储存格数值要设定百位、千位、万位、十万位、百万位、千万位(四舍五入)来显示
要如何自订呢?
例如:
123456789
百位:1234568
千位:123457
万位:12346
..............等依序
作者: jhg5702 (无奇)   2014-08-10 17:15:00
若 A1=123456789,百位=A1/100,千位=A1/1000,...依此类推
继续阅读
[请问] 问一首歌AItoai[请问] 直接开暴雪游戏decadeW[请问] ASUS P5KPL-VM/S 板子配线hanabi025[请问] 找一首英文歌yeeoo[请问] A&F的衣服chun1028[请问] 紫色隐形眼镜的颜色?king0026[请问] 想问问关于 DIY/加工 一个小礼物ghost900713[请问] 高美湿地今天傍晚可以去吗？wly[请问] 线上查黑猫宅急便已到营业所 可以自己拿?ina117700[请问] 进站画面soulknight

Links booklink

Contact Us: admin [ a t ] ucptt.com