kimberly

Selec those cells and DataText to ColumnsNextNext. Format as General and
Finish.


Gord Dibben Excel MVP

On 19 Apr 2005 13:36:23 -0700, wrote:

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