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