A1のセルに目的の数値を置いた場合
=CONCATENATE(RIGHT("00000000"&DEC2BIN(QUOTIENT(A1,2^24)),8)," ",RIGHT("00000000"&DEC2BIN(QUOTIENT( MOD(A1,2^24),2^16)),8)," ",RIGHT("00000000"&DEC2BIN(QUOTIENT(MOD(A1,2^16),2^8)),8)," ",RIGHT("00000000"&DEC2BIN(MOD(A1,2^8)),8))
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme