Tuesday, November 23rd, 2004 by
Now Where Did That Zero Go?
Here’s a good tip sent in by a reader regarding numbers with leading zeros.
If you’ve ever entered a number with a zero in the first place(s) you probably became very frustrated when you realized that Excel takes those zeros off the number.
For example, if you type in 01234 then, left to its own devices, Excel will put 1234 into the cell.
That’s… Continue reading