Kimberly

Not a mystery.

Simply changing formatting will not change the underlying value.

The value of 00000999 was text.

You must force it to change value as T to C did.


Gord Dibben Excel MVP

On 20 Apr 2005 16:53:45 -0700, wrote:

That was it! Now, how weird though, when I tried to format them as a
column with general format, they didn't truncate, only the text to
columns thing made it work. Mystery.