Chen Log

陳洛格

Excel 數字前填充0的方法

leave a comment »

螢幕快照 2017-07-15 下午4.15.05

若要在 Excel 儲存格的數值前面填充 0,

只要在儲存格格式的設立裡面打 0 即可,

例如 數字209 前面打 0000000000000000 填充12個0,

即可變成 0000000000000209 的形式。

Advertisements

Written by chenagw

2017/07/15 at 16:19

Posted in Uncategorized

Tagged with

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: