I WANT to truncate my leading zeros

[kimberly.shaffer]

I have a number of cells with 000000099999, and want to truncate the
leading zeros off. I have tried several different things with
formatting and can't figure it out, can someone help?

thanks

 

[Gord Dibben]

kimberly

Selec those cells and Data>Text to Columns>Next>Next. Format as General and
Finish.


Gord Dibben Excel MVP

 

[RagDyer]

OR ... depending on the desired final format,

Select the cells, then just:

<Data> <Text To Columns> <Finish>

--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
kimberly

Selec those cells and Data>Text to Columns>Next>Next. Format as General and
Finish.


Gord Dibben Excel MVP

 

[Gord Dibben]

Good point RD.

A few less steps which is always preferred.


Gord

 

[kimberly.shaffer]

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.

 

[Gord Dibben]

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