X

スポンサードリンク

スポンサードリンク

    Categories: メモ

エクセルの小数点の見え方について

<p><img data-attachment-id&equals;"7747" data-permalink&equals;"https&colon;&sol;&sol;www&period;eskyjapan&period;com&sol;memo&sol;decimal&sol;attachment&sol;08dee51911218dcd9c043e7946358c40&lowbar;s&sol;" data-orig-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;08dee51911218dcd9c043e7946358c40&lowbar;s&period;jpg&quest;fit&equals;640&percnt;2C427&amp&semi;ssl&equals;1" data-orig-size&equals;"640&comma;427" data-comments-opened&equals;"0" data-image-meta&equals;"&lbrace;&quot&semi;aperture&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;credit&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;camera&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;caption&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;created&lowbar;timestamp&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;copyright&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;focal&lowbar;length&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;iso&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;shutter&lowbar;speed&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;title&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;orientation&quot&semi;&colon;&quot&semi;0&quot&semi;&rcub;" data-image-title&equals;"08dee51911218dcd9c043e7946358c40&lowbar;s" data-image-description&equals;"" data-image-caption&equals;"" data-medium-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;08dee51911218dcd9c043e7946358c40&lowbar;s&period;jpg&quest;fit&equals;300&percnt;2C200&amp&semi;ssl&equals;1" data-large-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;08dee51911218dcd9c043e7946358c40&lowbar;s&period;jpg&quest;fit&equals;637&percnt;2C425&amp&semi;ssl&equals;1" class&equals;"aligncenter size-full wp-image-7747" src&equals;"https&colon;&sol;&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;08dee51911218dcd9c043e7946358c40&lowbar;s&period;jpg" alt&equals;"" width&equals;"640" height&equals;"427" &sol;><br &sol;>&NewLine;&NewLine;<&excl;-- WP QUADS Content Ad Plugin v&period; 2&period;0&period;98&period;1 -->&NewLine;<div class&equals;"quads-location quads-ad1" id&equals;"quads-ad1" style&equals;"float&colon;none&semi;margin&colon;0px&semi;">&NewLine;&NewLine;<&sol;div>&NewLine;<&sol;p>&NewLine;<p>通常の設定ではエクセルで小数点が省略されることはありません。<br &sol;>&NewLine;※関数や表示設定を変更していない限り<br &sol;>&NewLine;標準設定で、ある程度(少し)なら自動で幅が広がりますが、ある程度の数字は四捨五入して表示するようになります。<br &sol;>&NewLine;※表示だけが省略されているだけで、実際の数値はそのまま<br &sol;>&NewLine;なぜ少しだけなのか?<br &sol;>&NewLine;円周率など、無限大に続く数字があるから、どこまでも対応すると大変なことになるから<br &sol;>&NewLine;そして、そのまま印刷すると気が付かず・・・<br &sol;>&NewLine;それらの回避方法と綺麗に表示する方法を記事にしてみました。<&sol;p>&NewLine;<h3 class&equals;"style3b">セル幅に合わせてフォントサイズを自動調整<&sol;h3>&NewLine;<p>既存のセル幅に合わせて、フォントサイズを自動調整する方法で、印刷でも絶対に切れることはありません。<br &sol;>&NewLine;ただ、桁数が多すぎるとフォントサイズがめっちゃ小さくなるので、ある程度限度はありますが・・・<&sol;p>&NewLine;<h4 class&equals;"style4a">設定方法<&sol;h4>&NewLine;<p><img data-attachment-id&equals;"7737" data-permalink&equals;"https&colon;&sol;&sol;www&period;eskyjapan&period;com&sol;memo&sol;decimal&sol;attachment&sol;2018-12-15&lowbar;1&sol;" data-orig-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;1&period;jpg&quest;fit&equals;368&percnt;2C153&amp&semi;ssl&equals;1" data-orig-size&equals;"368&comma;153" data-comments-opened&equals;"0" data-image-meta&equals;"&lbrace;&quot&semi;aperture&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;credit&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;camera&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;caption&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;created&lowbar;timestamp&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;copyright&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;focal&lowbar;length&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;iso&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;shutter&lowbar;speed&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;title&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;orientation&quot&semi;&colon;&quot&semi;0&quot&semi;&rcub;" data-image-title&equals;"2018&period;12&period;15&lowbar;1" data-image-description&equals;"" data-image-caption&equals;"" data-medium-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;1&period;jpg&quest;fit&equals;300&percnt;2C125&amp&semi;ssl&equals;1" data-large-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;1&period;jpg&quest;fit&equals;368&percnt;2C153&amp&semi;ssl&equals;1" class&equals;"aligncenter size-full wp-image-7737" src&equals;"https&colon;&sol;&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;1&period;jpg" alt&equals;"" width&equals;"368" height&equals;"153" &sol;><br &sol;>&NewLine;参考として、「D1」のせるには「10000&period;123」の数字を入力していますが、最後の1桁だけ省略されています。<br &sol;>&NewLine;※省略された数字が3だったので四捨五入で切り捨てられています。<br &sol;>&NewLine;D1~D5までそれぞれの桁数を入力していますが、今のままでは同じ表示です。<br &sol;>&NewLine;セルを選択し、その上で右クリック<br &sol;>&NewLine;<img data-attachment-id&equals;"7738" data-permalink&equals;"https&colon;&sol;&sol;www&period;eskyjapan&period;com&sol;memo&sol;decimal&sol;attachment&sol;2018-12-15&lowbar;2&sol;" data-orig-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;2&period;jpg&quest;fit&equals;350&percnt;2C500&amp&semi;ssl&equals;1" data-orig-size&equals;"350&comma;500" data-comments-opened&equals;"0" data-image-meta&equals;"&lbrace;&quot&semi;aperture&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;credit&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;camera&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;caption&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;created&lowbar;timestamp&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;copyright&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;focal&lowbar;length&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;iso&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;shutter&lowbar;speed&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;title&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;orientation&quot&semi;&colon;&quot&semi;0&quot&semi;&rcub;" data-image-title&equals;"2018&period;12&period;15&lowbar;2" data-image-description&equals;"" data-image-caption&equals;"" data-medium-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;2&period;jpg&quest;fit&equals;210&percnt;2C300&amp&semi;ssl&equals;1" data-large-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;2&period;jpg&quest;fit&equals;298&percnt;2C425&amp&semi;ssl&equals;1" class&equals;"aligncenter size-full wp-image-7738" src&equals;"https&colon;&sol;&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;2&period;jpg" alt&equals;"" width&equals;"350" height&equals;"500" &sol;><br &sol;>&NewLine;「セルの書式設定」をクリック<br &sol;>&NewLine;<img data-attachment-id&equals;"7739" data-permalink&equals;"https&colon;&sol;&sol;www&period;eskyjapan&period;com&sol;memo&sol;decimal&sol;attachment&sol;2018-12-15&lowbar;3&sol;" data-orig-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;3&period;jpg&quest;fit&equals;350&percnt;2C500&amp&semi;ssl&equals;1" data-orig-size&equals;"350&comma;500" data-comments-opened&equals;"0" data-image-meta&equals;"&lbrace;&quot&semi;aperture&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;credit&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;camera&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;caption&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;created&lowbar;timestamp&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;copyright&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;focal&lowbar;length&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;iso&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;shutter&lowbar;speed&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;title&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;orientation&quot&semi;&colon;&quot&semi;0&quot&semi;&rcub;" data-image-title&equals;"2018&period;12&period;15&lowbar;3" data-image-description&equals;"" data-image-caption&equals;"" data-medium-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;3&period;jpg&quest;fit&equals;210&percnt;2C300&amp&semi;ssl&equals;1" data-large-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;3&period;jpg&quest;fit&equals;298&percnt;2C425&amp&semi;ssl&equals;1" class&equals;"aligncenter size-full wp-image-7739" src&equals;"https&colon;&sol;&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;3&period;jpg" alt&equals;"" width&equals;"350" height&equals;"500" &sol;><br &sol;>&NewLine;「配置」タブをクリック<br &sol;>&NewLine;文字の制御の部分に「縮小して全体を表示する」にチェック<br &sol;>&NewLine;<img data-attachment-id&equals;"7740" data-permalink&equals;"https&colon;&sol;&sol;www&period;eskyjapan&period;com&sol;memo&sol;decimal&sol;attachment&sol;2018-12-15&lowbar;4&sol;" data-orig-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;4&period;jpg&quest;fit&equals;620&percnt;2C400&amp&semi;ssl&equals;1" data-orig-size&equals;"620&comma;400" data-comments-opened&equals;"0" data-image-meta&equals;"&lbrace;&quot&semi;aperture&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;credit&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;camera&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;caption&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;created&lowbar;timestamp&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;copyright&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;focal&lowbar;length&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;iso&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;shutter&lowbar;speed&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;title&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;orientation&quot&semi;&colon;&quot&semi;0&quot&semi;&rcub;" data-image-title&equals;"2018&period;12&period;15&lowbar;4" data-image-description&equals;"" data-image-caption&equals;"" data-medium-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;4&period;jpg&quest;fit&equals;300&percnt;2C194&amp&semi;ssl&equals;1" data-large-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;4&period;jpg&quest;fit&equals;620&percnt;2C400&amp&semi;ssl&equals;1" class&equals;"aligncenter size-full wp-image-7740" src&equals;"https&colon;&sol;&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;4&period;jpg" alt&equals;"" width&equals;"620" height&equals;"400" &sol;><br &sol;>&NewLine;最後に、右下の「OK&rsqb;を押します。<br &sol;>&NewLine;この方法では、決められたセル幅にフォントを小さくして無理にでも表示させます。<br &sol;>&NewLine;だから、結果としてこのように表示されることになります。<br &sol;>&NewLine;<img data-attachment-id&equals;"7741" data-permalink&equals;"https&colon;&sol;&sol;www&period;eskyjapan&period;com&sol;memo&sol;decimal&sol;attachment&sol;2018-12-15&lowbar;5&sol;" data-orig-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;5&period;jpg&quest;fit&equals;330&percnt;2C150&amp&semi;ssl&equals;1" data-orig-size&equals;"330&comma;150" data-comments-opened&equals;"0" data-image-meta&equals;"&lbrace;&quot&semi;aperture&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;credit&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;camera&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;caption&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;created&lowbar;timestamp&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;copyright&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;focal&lowbar;length&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;iso&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;shutter&lowbar;speed&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;title&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;orientation&quot&semi;&colon;&quot&semi;0&quot&semi;&rcub;" data-image-title&equals;"2018&period;12&period;15&lowbar;5" data-image-description&equals;"" data-image-caption&equals;"" data-medium-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;5&period;jpg&quest;fit&equals;300&percnt;2C136&amp&semi;ssl&equals;1" data-large-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;5&period;jpg&quest;fit&equals;330&percnt;2C150&amp&semi;ssl&equals;1" class&equals;"aligncenter size-full wp-image-7741" src&equals;"https&colon;&sol;&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;5&period;jpg" alt&equals;"" width&equals;"330" height&equals;"150" &sol;><&sol;p>&NewLine;<h3 class&equals;"style3b">セル幅を数字に合わせて自動で合わせる<&sol;h3>&NewLine;<p>セル幅を自動調整する方法として、列の右側の線にポインターをあわせると、マウスの表示がこのように変わる所があります。<br &sol;>&NewLine;<img data-attachment-id&equals;"7742" data-permalink&equals;"https&colon;&sol;&sol;www&period;eskyjapan&period;com&sol;memo&sol;decimal&sol;attachment&sol;2018-12-15&lowbar;6&sol;" data-orig-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;6&period;jpg&quest;fit&equals;350&percnt;2C160&amp&semi;ssl&equals;1" data-orig-size&equals;"350&comma;160" data-comments-opened&equals;"0" data-image-meta&equals;"&lbrace;&quot&semi;aperture&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;credit&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;camera&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;caption&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;created&lowbar;timestamp&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;copyright&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;focal&lowbar;length&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;iso&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;shutter&lowbar;speed&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;title&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;orientation&quot&semi;&colon;&quot&semi;0&quot&semi;&rcub;" data-image-title&equals;"2018&period;12&period;15&lowbar;6" data-image-description&equals;"" data-image-caption&equals;"" data-medium-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;6&period;jpg&quest;fit&equals;300&percnt;2C137&amp&semi;ssl&equals;1" data-large-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;6&period;jpg&quest;fit&equals;350&percnt;2C160&amp&semi;ssl&equals;1" class&equals;"aligncenter size-full wp-image-7742" src&equals;"https&colon;&sol;&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;6&period;jpg" alt&equals;"" width&equals;"350" height&equals;"160" &sol;><br &sol;>&NewLine;この状態で、ダブルクリックしてみてください。<br &sol;>&NewLine;<img data-attachment-id&equals;"7743" data-permalink&equals;"https&colon;&sol;&sol;www&period;eskyjapan&period;com&sol;memo&sol;decimal&sol;attachment&sol;2018-12-15&lowbar;7&sol;" data-orig-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;7&period;jpg&quest;fit&equals;360&percnt;2C160&amp&semi;ssl&equals;1" data-orig-size&equals;"360&comma;160" data-comments-opened&equals;"0" data-image-meta&equals;"&lbrace;&quot&semi;aperture&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;credit&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;camera&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;caption&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;created&lowbar;timestamp&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;copyright&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;focal&lowbar;length&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;iso&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;shutter&lowbar;speed&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;title&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;orientation&quot&semi;&colon;&quot&semi;0&quot&semi;&rcub;" data-image-title&equals;"2018&period;12&period;15&lowbar;7" data-image-description&equals;"" data-image-caption&equals;"" data-medium-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;7&period;jpg&quest;fit&equals;300&percnt;2C133&amp&semi;ssl&equals;1" data-large-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;7&period;jpg&quest;fit&equals;360&percnt;2C160&amp&semi;ssl&equals;1" class&equals;"aligncenter size-full wp-image-7743" src&equals;"https&colon;&sol;&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;7&period;jpg" alt&equals;"" width&equals;"360" height&equals;"160" &sol;><br &sol;>&NewLine;このように、フォントサイズはそのままで、セル幅を適切なサイズに自動調節してくれました。<br &sol;>&NewLine;どちらの方法であっても、これで印刷時に小数点が切れることはありません。<&sol;p>&NewLine;<h3 class&equals;"style3b">小数点の位置を揃えて表示<&sol;h3>&NewLine;<p>ついでに、小数点の位置をそろえて表示させる方法も書いておきます。<br &sol;>&NewLine;<img data-attachment-id&equals;"7744" data-permalink&equals;"https&colon;&sol;&sol;www&period;eskyjapan&period;com&sol;memo&sol;decimal&sol;attachment&sol;2018-12-15&lowbar;8&sol;" data-orig-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;8&period;jpg&quest;fit&equals;270&percnt;2C120&amp&semi;ssl&equals;1" data-orig-size&equals;"270&comma;120" data-comments-opened&equals;"0" data-image-meta&equals;"&lbrace;&quot&semi;aperture&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;credit&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;camera&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;caption&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;created&lowbar;timestamp&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;copyright&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;focal&lowbar;length&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;iso&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;shutter&lowbar;speed&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;title&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;orientation&quot&semi;&colon;&quot&semi;0&quot&semi;&rcub;" data-image-title&equals;"2018&period;12&period;15&lowbar;8" data-image-description&equals;"" data-image-caption&equals;"" data-medium-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;8&period;jpg&quest;fit&equals;270&percnt;2C120&amp&semi;ssl&equals;1" data-large-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;8&period;jpg&quest;fit&equals;270&percnt;2C120&amp&semi;ssl&equals;1" class&equals;"aligncenter size-full wp-image-7744" src&equals;"https&colon;&sol;&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;8&period;jpg" alt&equals;"" width&equals;"270" height&equals;"120" &sol;><br &sol;>&NewLine;普通に入力すると、「A列」のようになりますが、「C列」の表示を見ると、小数点の位置が揃っていて、見やすくなると思いませんか?<br &sol;>&NewLine;この表示方法の設定はとても簡単<br &sol;>&NewLine;先ほどと同じ要領で、セル範囲を選択して、右クリックしてから「セルの書式設定」を選択します。<br &sol;>&NewLine;<img data-attachment-id&equals;"7745" data-permalink&equals;"https&colon;&sol;&sol;www&period;eskyjapan&period;com&sol;memo&sol;decimal&sol;attachment&sol;2018-12-15&lowbar;9&sol;" data-orig-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;9&period;jpg&quest;fit&equals;300&percnt;2C450&amp&semi;ssl&equals;1" data-orig-size&equals;"300&comma;450" data-comments-opened&equals;"0" data-image-meta&equals;"&lbrace;&quot&semi;aperture&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;credit&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;camera&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;caption&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;created&lowbar;timestamp&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;copyright&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;focal&lowbar;length&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;iso&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;shutter&lowbar;speed&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;title&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;orientation&quot&semi;&colon;&quot&semi;0&quot&semi;&rcub;" data-image-title&equals;"2018&period;12&period;15&lowbar;9" data-image-description&equals;"" data-image-caption&equals;"" data-medium-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;9&period;jpg&quest;fit&equals;200&percnt;2C300&amp&semi;ssl&equals;1" data-large-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;9&period;jpg&quest;fit&equals;283&percnt;2C425&amp&semi;ssl&equals;1" class&equals;"aligncenter size-full wp-image-7745" src&equals;"https&colon;&sol;&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;9&period;jpg" alt&equals;"" width&equals;"300" height&equals;"450" &sol;><br &sol;>&NewLine;次に、「表示形式」のタブを選択し、「ユーザー定義」をクリック<br &sol;>&NewLine;矢印の欄に<span id&equals;"i-6"><span style&equals;"font-size&colon; 14pt&semi;"><strong>「0&period;&quest;&quest;&quest;」<&sol;strong><&sol;span>と入力します。<&sol;span><br &sol;>&NewLine;<img data-attachment-id&equals;"7746" data-permalink&equals;"https&colon;&sol;&sol;www&period;eskyjapan&period;com&sol;memo&sol;decimal&sol;attachment&sol;2018-12-15&lowbar;10&sol;" data-orig-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;10&period;jpg&quest;fit&equals;520&percnt;2C540&amp&semi;ssl&equals;1" data-orig-size&equals;"520&comma;540" data-comments-opened&equals;"0" data-image-meta&equals;"&lbrace;&quot&semi;aperture&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;credit&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;camera&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;caption&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;created&lowbar;timestamp&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;copyright&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;focal&lowbar;length&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;iso&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;shutter&lowbar;speed&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;title&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;orientation&quot&semi;&colon;&quot&semi;0&quot&semi;&rcub;" data-image-title&equals;"2018&period;12&period;15&lowbar;10" data-image-description&equals;"" data-image-caption&equals;"" data-medium-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;10&period;jpg&quest;fit&equals;289&percnt;2C300&amp&semi;ssl&equals;1" data-large-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;10&period;jpg&quest;fit&equals;409&percnt;2C425&amp&semi;ssl&equals;1" class&equals;"aligncenter size-full wp-image-7746" src&equals;"https&colon;&sol;&sol;www&period;eskyjapan&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;2018&period;12&period;15&lowbar;10&period;jpg" alt&equals;"" width&equals;"520" height&equals;"540" &sol;><br &sol;>&NewLine;最後に、右下の「OK&rsqb;を押します。<&sol;p>&NewLine;<h3 class&equals;"style3b">さいごに<&sol;h3>&NewLine;<p>印刷する前にプレビューをすれば、このミスは防止できると思うかもしれませんが、そんなに簡単な話ではありません。<br &sol;>&NewLine;エクセルは、想像以上にいろんな事ができます。<br &sol;>&NewLine;積み重ねていけば、とても便利になるツールですから、少しだけお手伝いさせていただきました。<br &sol;>&NewLine;&NewLine;<&excl;-- WP QUADS Content Ad Plugin v&period; 2&period;0&period;98&period;1 -->&NewLine;<div class&equals;"quads-location quads-ad3" id&equals;"quads-ad3" style&equals;"float&colon;none&semi;margin&colon;0px&semi;">&NewLine;&NewLine;<&sol;div>&NewLine;<br &sol;>&NewLine;&NewLine;<&excl;-- WP QUADS Content Ad Plugin v&period; 2&period;0&period;98&period;1 -->&NewLine;<div class&equals;"quads-location quads-ad4" id&equals;"quads-ad4" style&equals;"float&colon;none&semi;margin&colon;0px 0 0px 0&semi;text-align&colon;center&semi;">&NewLine;&NewLine;<&sol;div>&NewLine;<&sol;p>&NewLine;&NewLine;

葉隠 瀧: このサイトを管理しているのが葉隠 瀧です。
Related Post