I WANT to truncate my leading zeros

K

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
 
G

Gord Dibben

kimberly

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


Gord Dibben Excel MVP
 
R

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
 
K

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.
 
G

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
 
Top