Excel関数(文字列⇔数値)

■数値を文字列に変換

=TEXT(1234,“0000000”)

先頭のゼロ (0) を追加 (例: 0001234)

■文字列を数値に変換

=VALUE(0001234) 

先頭のゼロ (0) を省略 (例: 1234)

About

You may also like...

Your email will not be published. Name and Email fields are required