formula =INT(A1/1000). You will notice that although both cells B1 and C1 contain
the result of extracting the leftmost digit of the number in A1, the two cells are format-
ted differently. The digit 7 in cell B1 is left-aligned while it is shown right-aligned in C1.
This is due to the fact that Excel is treating digit 7 in cell B1 as text, the result of a text
function LEFT, and Excel automatically formats text entries as left-aligned. Now look at
the result of the formula =VALUE(B1) in cell D1. Through the VALUE function, digit
7 of cell B1 has been transformed from text to a number in cell D1 and hence it is being
displayed ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.