LoginSignup
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 5 years have passed since last update.

@koara-localinリックソフト株式会社

[Excel] 数値 => 文字列の0埋め(整数の上位桁、小数点以下の桁の設定）

Posted at

ちょくちょく使うけどもすぐ忘れるのでメモ。
TEXT(値,表示形式) を使用する。

使用例

無題.png

出来ること

  • 整数の上位桁の０埋め表示
  • 小数点以下の０埋め表示
  • 小数点以下の桁数の制限(例では小数点以下9桁=>2桁)
  • 他の文字列と組み合わせる

セルの書式設定でもできるけれども、こっちだと文章への埋め込みができるので地味に便利。

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?