TELECOM Digest OnLine - Sorted: Re: Leading Zeros?

Re: Leading Zeros?

Brad Houser (
Wed, 16 Feb 2005 12:40:50 -0800

AES <> wrote in message

> A few quick tests show that the default behavior is to automatically
> and irretrievably discard leading zeros on integer numbers keyed
> into an Exce l worksheet cell or a Mathematic list.

If you enter the number in Excel with an apostrophe in front it will be
stored it as a number but display it as entered:

'00001 displays as 00001

Brad Houser

Post Followup Article Use your browser's quoting feature to quote article into reply
Go to Next message: William Warren: "Re: Leading Zeros?"
Go to Previous message: Justin Time: "Re: Leading Zeros?"
May be in reply to: AES: "Leading Zeros?"
Next in thread: William Warren: "Re: Leading Zeros?"
TELECOM Digest: Home Page