Friday, November 19th, 2004
The Leading Zero
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.
Convenient when you’re actually dealing with numbers, but a pain when it’s a… Continue reading