Help us understand the problem. What is going on with this article?

【俺メモ】Excelで文字列になっている数字を一発で数値に戻す方法

More than 5 years have passed since last update.

エクセルで書式が文字列になっているセルに数字が入力されていた場合、
書式を標準や数値にしても左詰めのまんまやろ?

もしかして、F2→Enterの繰り返しをカタカタやってんのとちゃうやろな?

そんなときはこれ一発で解決や。

1.数値に戻したいセルを選択

マウスドラッグでも、Ctrl + Shift + 矢印でもええから変更したい所を選択や

2.セルの書式を標準(数値)に変更

リボン(メニュー)でも書式ダイアログでもええからまず、書式を標準(数値)に変更や

3.区切り位置変更で解決

メニューの「データ」の中にある「区切り位置」からダイアログを表示や、
そのあとすぐにダイアログの完了ボタンをおすとええで。

Why not register and get more from Qiita?
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
Comments
No comments
Sign up for free and join this conversation.
If you already have a Qiita account
Why do not you register as a user and use Qiita more conveniently?
You need to log in to use this function. Qiita can be used more conveniently after logging in.
You seem to be reading articles frequently this month. Qiita can be used more conveniently after logging in.
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
ユーザーは見つかりませんでした