Friday, May 5th, 2006
The Leading Zero
Are you constantly frustrated with MS Excel, because it keeps removing that leading zero from your inventory number? (Or any leading zero on any piece of data?)
Yeah, me too.
The problem is that Excel automatically sees the data as a number and leading zeros have no value in numbers, so it gets rid of them.
It’s convenient when you’re actually dealing with numbers, but a pain… Continue reading