You can use TTC (Text To Columns).

Select your column of data, then,
<Data <TextToColumns
Click on "Fixed Width", then <Next

Click in the "Data Preview" window and place the 'break line' to separate
the zeroes,
Then <Next

In the "Data Preview" window you see the first column of 0's selected by
default.
Click on "Do Not Import Column"
You see the header change from 'General' to "skip".

Then click on the second column containing your numbers.
Click on "Text", since you have 16 digits remaining.
Then <Finish.
--

HTH,

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

"dalipsinghbisht"
<dalipsinghbisht.24td3y_1142598600.792@excelforu m-nospam.com wrote in
message news:dalipsinghbisht.24td3y_1142598600.792@excelfo rum-nospam.com...

Hi Friends,

Thanks for your quick reply
Andy's second formula is working but zim's not coz it shows zero in
last......


Dalip


--
dalipsinghbisht
------------------------------------------------------------------------
dalipsinghbisht's Profile:
http://www.excelforum.com/member.php...o&userid=32557
View this thread: http://www.excelforum.com/showthread...hreadid=523514