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.