Numbers left-aligned in a cell

  • Thread starter Thread starter Epinn
  • Start date Start date
E

Epinn

I can enter a number as text by

(1) formatting the cell as text
or
(2) leaving the format as general but keying in a single quote with the number e.g. '76.

Either way, the number will be left-aligned with a green triangle i.e. if I invoke error checking. If I untick error checking and don't notice the left alignment, the single quote should alert me that the number is in text format, right?

Do you see another difference between (1) and (2) especially in terms of application of the number (in text format)?

Thanks.

Epinn
 
You aren't going to see the single quote except when you have the cell
selected.

Since there may be possibility of someone choosing (either intentionally or
accidentally) left alignment for the cell, even its position/alignment isn't
a sure bet as a clue.

If you're going 'public' with it, probably best to format the cell as Text
so that the end user won't have to deal with remembering to enter number with
' in front of it?
 
Thank you.
accidentally) left alignment for the cell......

Good point.

Epinn

You aren't going to see the single quote except when you have the cell
selected.

Since there may be possibility of someone choosing (either intentionally or
accidentally) left alignment for the cell, even its position/alignment isn't
a sure bet as a clue.

If you're going 'public' with it, probably best to format the cell as Text
so that the end user won't have to deal with remembering to enter number with
' in front of it?
 
You can use the alignment as a quick way to see if you have real
numbers or text values that look like numbers. For example, say you
have imported a column of dates: set the alignment for the column to
general and widen the column considerably. If the dates are "real"
dates then they will appear on the right of the column, but if they are
text values they will appear on the left, and the same applies for
other numbers which may really be text.

Hope this helps.

Pete
 
Thanks for your post and I always love little tricks and shortcuts.

The first time I read your post and caught the word "general," I was fixated on format>cell>number>general and I scratched my head. Then, I reread and realized you might mean format>cell>alignment>horizontal>general. Any true numbers that are left aligned will be easily revealed when I do format>cell>alignment because under horizontal it shows "left (indent)." I'll remember this trick.

It is solid proof to use ISTEXT or ISNUMBER, right?

Epinn

You can use the alignment as a quick way to see if you have real
numbers or text values that look like numbers. For example, say you
have imported a column of dates: set the alignment for the column to
general and widen the column considerably. If the dates are "real"
dates then they will appear on the right of the column, but if they are
text values they will appear on the left, and the same applies for
other numbers which may really be text.

Hope this helps.

Pete
 
Back
Top